Le 1 mars 2006 à 21:18, Ian R a écrit :
Row-level locking is only supported in MySQL if you are using the
InnoDB engine (default is MyISAM).
I'm using InnoDB
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)
I have a big book about MySQL where I read things about "LOCK FOR
UPDATE", "LOCK IN SHARE MODE", etc. All these features seem to suit
my needs, but I can make them work.
Thanks for your help
Eric
_______________________________________________
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>
