I built a class that handles transactions but do this. db.sqlexecute("Lock Tables tablePhone WRITE") edit the record using update or something similar then db.sqlexecute("UNLOCK TABLES;")The problem for me with this method is that you lock the whole table, which is not good for my needs...
Row-level locking is only supported in MySQL if you are using the InnoDB engine (default is MyISAM).
If you are, I believe you could send an SQLExecute message to the affect of "SELECT columns FROM table FOR UPDATE" or "SELECT columns FROM table LOCK IN SHARE MODE" depending on what you're planning to do. (I've never actually done this)
But I also find that if something is particularly difficult to do, it's because I'm trying to do in it a particularly difficult way. So you may want to re-think what you are doing, or if you really can't use table-level locking. Of course, I don't know what you're trying to do or your level of experience with MySQL.
Good Luck! Ian _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
