>-----Original Message----- >From: Fernando Grijalba [mailto:fernando@;ggtours.on.ca] >Sent: Wednesday, November 06, 2002 11:41 AM >To: MySQL Help >Subject: InnoDB row level locking? > > >In the documentation it says that InnoDB supports row level >locking. How >can I ensure that rows are locked using ADO in a VB Applications >communicating with MySQL through MyODBC? > >I have tried setting my Recordsets to adLockPessimistic, but >that does not >seam to work.
Make sure you are working inside transactions. then add this text to the end of your select statments "FOR UPDATE" This will ensure that no one else updates after you have selected the record. But it will still let others read. Commiting your transaction will release the lock. sean. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
