Claude Schneegans wrote: >> SELECT * FROM table WHERE id = blah FOR UPDATE > > Ok, but I think this syntax is proper to Oracle.
It may have originated there, but it has been in the SQL standard since at least 1992. > - I don't see it documented in Access, SQL Server MS calls it WITH updlock. You would have to ask them why they don't just call it the same as the rest of the world. > - In MySql, there is only LOCK TABLES, http://dev.mysql.com/doc/refman/4.1/en/innodb-locking-reads.html PostgreSQL, DB2, Mimer etc. all understand FOR UPDATE. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4