General information
Title:
Failed delete won't release lock
VFP8.0
database Sybase Adaptive Server Anywhere 8.02.
If I am using automatic transactions and issue a delete that will fail because of foreign key constraints, the row stays locked and the only way to unlock the row is to disconnect from the database. Using manual transactions does not work because I don’t get the error from the database. The only way I can get this to work is to add “begin transaction;” to the delete and then issue a rollback if it fails. Is this the proper way to handle this or am I missing something?
UPDATE
I found the problem with manual transactions so that is another option.
Thanks
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only