I've tried every isolation level. First I tried by modifying the isolation level as defined in the windows odbc dsn setup -- then I tried by modifying my connection strings (I'm connecting using C# .NET) in my code. In every case I could not hold a lock for any period of time beyond the read...
Hello,
I'm hoping someone can shed some light on the ability to lock rows in Progress via ODBC.
In short I'd like to be able to do some pessimistic locking. This works using sqlexp on our server with a transaction of the form:
SELECT x,y FROM TABLE z WHERE ... FOR UPDATE;
UPDATE z SET...
Hello, I have a question about locking in the other direction. Unless I am incorrectly setting up the isolation level of my connections I don't seem to have any luck in holding a lock myself.
Here is my question: if I want to update a row in a table, is there any way for me to lock that row in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.