Re: Record locking INNODB
Can I test to see if a record is already locked before making a Select call?
Currently I am using:
SELECT * FROM tablename WHERE fieldname = key FOR UPDATE, conn, adOpenStatic
but if this record is locked it waits for it to unlock or until a 30 second timeout. I would like to let the user know the record is in use and give him the option of aborting.
Thanks.
Bill Baur
bbaur@AFPFire.Com
Subject
Views
Written By
Posted
7824
February 01, 2005 02:15PM
3550
February 01, 2005 02:52PM
3301
February 02, 2005 04:06AM
3399
February 04, 2005 01:35PM
Re: Record locking INNODB
3264
February 02, 2005 12:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.