Is there any means of doing a SELECT for UPDATE, ie to lock a record in a transaction?
I mark every record with a 'LastUpdated' timestamp in order to be able to check whether it has been updated in the meantime in another session. Before any UPDATE or DELETE I re-read the record and compare timestamps. But the record really needs to be locked; otherwise there is still a window between the SELECT and the UPDATE during which another session could modify or delete it.
Does anyone know how to achieve this through Torque?
--
Regards,
Tarlika Elisabeth Schmitz
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
