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