Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to effect a NOWAIT in the LOCK TABLES statement?

Status
Not open for further replies.

Arthur Lewis

Programmer
Jul 10, 2021
9
LC
SELECT ... FOR UPDATE has a NOWAIT predicate that returns -1 via ODBC if you can't acquire the relevant lock. LOCK TABLES does not have that option but I need it. I am copying from some tables which I want to lock. However, I want to move on immediately if the locks can't be acquired. I don't want to wait. Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top