Arthur Lewis
Programmer
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?