Search:

Type: Posts; User: Focus

Page 1 of 80 1 2 3 4

Search: Search took 0.05 seconds; generated 3 minute(s) ago.

  1. Replies
    2
    Views
    124

    Re: Studio error saving system table

    It seems to be working for me today so no

    It's not something I do very often so it is not a big problem
  2. Replies
    2
    Views
    124

    Studio error saving system table

    Just had this error (which may not be new) when saving a record in the studio to a system table

    The save succeeded but I guess there is no next record to read

    C:\Program Files\DataFlex...
  3. Replies
    11
    Views
    231

    Re: Error BindColumnsToHandle

    It seems to stop before a SELECT is even sent to the SQL server

    i.e. the SQL profiler is not showing anything as sent
  4. Replies
    11
    Views
    231

    Re: Error BindColumnsToHandle

    Sorry still stumped
  5. Replies
    11
    Views
    231

    Re: Error BindColumnsToHandle

    Actually it can't be that as no system tables seem to have an index

    red-herring
  6. Replies
    11
    Views
    231

    Re: Error BindColumnsToHandle

    Ah, looks like something has happend to the index

    The studio reports

    Index 0 ()

    i.e. it has no name

    and the index seems to have gone from the SQL side
  7. Replies
    11
    Views
    231

    Re: Error BindColumnsToHandle

    It's a DD find operation on a system table

    Send Find GT 0

    I've tried setting Error_Debug_Mode in MSSQLDRV.INT but it is not giving me any more info
  8. Replies
    11
    Views
    231

    Re: Error BindColumnsToHandle

    Please can I have more information on what this error means and under what conditions it is raised

    I have undone all my recent changes and I am still getting it in code that has not changed
    ...
  9. Replies
    11
    Views
    231

    Error BindColumnsToHandle

    I'm getting this BindColumnsToHandle error

    Initially I thought it might suggest some sort of structure mismatch

    But I'm now thinking something might have changed recently in the CK in relation...
  10. Replies
    8
    Views
    219

    Re: JSON REST Blank Elements

    I assume you have seen this from Harm on the forums elsewhere to remove the empty members

    It wont cover all scenarios but it might help



    Procedure RemoveEmptyMembers Handle hoJsonObj...
  11. Thread: Formatting XML

    by Focus
    Replies
    9
    Views
    289

    Re: Formatting XML

    If you mean for occasional use/debugging Notepad++ will format it for you with a plugin
  12. Replies
    14
    Views
    470

    Re: RC Runtime Issues

    It feels like the generated JS code in the browser has a comma or semicolon missing or a bracket in the wrong place that is creating havoc that seems to make no logical sense

    Or = instead of ==
  13. Replies
    14
    Views
    470

    Re: RC Runtime Issues

    If you Press F12 in Chrome and look at the Issues tab at the bottom of the screen does it give any clues?

    There is lots of stuff in there a bit like DAE compiler warnings but something might leap...
  14. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    The main challenge with this approach is the non technical users

    The machine it uses is not on
    OK so it is on a server but the process did not work and has hung and no one can easily see it...
  15. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    OK finally getting somewhere

    I tried this



    set transaction isolation level serializable
    begin transaction;
    select SomeDate from MyTable with (HOLDLOCK,TABLOCKX) where Id=3;
    WAITFOR DELAY...
  16. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    Well the allegedly world dominating ChatGPT give conflicting answers

    If I ask

    prevent mssql server from reading a row

    It says you can't it will read a row if it has permissions etc

    But if...
  17. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    I tried this in two SSMS tabs and kicked them off one after the other


    begin transaction;
    select SomeDate from MyTable with (HOLDLOCK,TABLOCKX) where Id=3;
    WAITFOR DELAY '00:00:10';
    update...
  18. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    The updating of record is the least important part of this process

    I just need to find a "perfect" way that many machines can call/check on something that tells them if they should run a process
    ...
  19. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    I don't see how OnPostFind helps. Two systems can still read at the same time before they get to OnPostFind

    Ironically if it did not have issues with small record sizes and file buffers and the...
  20. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    In terms of what goes to the SQL server if I do something simple like this



    Open MyTable
    Begin_Transaction
    Clear MyTable
    Move 3 to MyTable.Pk
    Find eq MyTable by Index.1
    Reread MyTable
  21. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    Hi Martin

    Do you have a view?

    Thanks
  22. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    Re: ESQL and ROWLOCK

    Thanks Vincent

    Whilst I can always do with a re-fresher I do understand the jist of the way locks work.

    In the context of that last link I'm saying I want to obtain an exclusive lock on a row...
  23. Thread: ESQL and ROWLOCK

    by Focus
    Replies
    20
    Views
    786

    ESQL and ROWLOCK

    Can we use ROWLOCK with ESQL similar to here

    How to avoid concurrent read access issue in SQL Server? - Stack Overflow

    I'm not looking to do exactly this but I do need to find a way that if two...
  24. Replies
    2
    Views
    207

    DF24.0 Locals window quirk with paths

    If you have a local string variable containing a file path in the locals window it looks correct

    However when you click into it to copy it all of the slashes are duplicated

    i.e.
    ...
  25. Thread: com Object call

    by Focus
    Replies
    6
    Views
    286

    Re: com Object call

    Have you looked in the PRN file for that line number to see what is there?
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4