Page 1 of 1

savepoint 'LOCK_controlname' never established for TOraTable

Posted: Wed 17 Jan 2007 16:05
by TOMWILK
I am getting "savepoint 'LOCK_controlname' never established" for numerous TOraTable components at run-time. The error definetely occurs when the dataset goes into Edit and then Cancel is called. I am running Delphi 6, update 2 with the Fast4MM memory manager. My ODAC component source is odac580src.exe dated September 13, 2006 at 4:13PM. Do I have the latest? If not, how do I get it?

Also, I am running against Oracle 10g R2 server using the Oracle 9.2 client libraries.

I am wondering if this is related to this post => http://www.crlab.com/forums/viewtopic.p ... =savepoint

I am not sure what to do next. Any help would be much appreciated.

Posted: Thu 18 Jan 2007 09:40
by Challenger
This is designed behavior. You see this exceptions only in IDE and only if the "Stop on Delphi Exceptions" option is enabled. ODAC uses save points for establishing record locks. This situation can be reproduced in the following case. You edit data in Table1 and Table2. And then you try to cancel changes in Table2 after you cancel changes in Table1.

Posted: Thu 18 Jan 2007 15:55
by TOMWILK
Thanks. I've got the idea. If I were to Cancel (rollback under the hood) in the correct sequence, then I would not see this exception, correct?