I'm not sure what caused it and a close open of the studio has fixed it but all my debugger buttons were grey when I was stopped on a breakpoint
I could click Run and that did the same as Continue...
Type: Posts; User: Focus
I'm not sure what caused it and a close open of the studio has fixed it but all my debugger buttons were grey when I was stopped on a breakpoint
I could click Run and that did the same as Continue...
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
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...
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
Sorry still stumped
Actually it can't be that as no system tables seem to have an index
red-herring
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
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
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
...
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...
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...
If you mean for occasional use/debugging Notepad++ will format it for you with a plugin
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 ==
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...
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...
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...
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...
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...
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
...
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...
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
Hi Martin
Do you have a view?
Thanks
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...
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...
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.
...