LOCKS and TRANSACTIONS

[Menachem Bazian]

Hi,

I have been doing quite a bit with VFP9 and MySQL and am now working on adding some functionality to my VFP framework. I use ODBC and SQL PassThru to transmit data to/fro the mysql.

My question deals with Update conflicts and transactions. I was wondering if anyone here had any ideas how to deal with changes made to a record by another user while the current user is in an edit session. As a corrolary to that, I was wondering if there might be a locking mechanism in MySQL that would allow me to, in effect, pessimistically lock an object (meaning, noone could edit it while the current user does).

As a second issue, how does one implement transactions in MySQL using ODBC? I am a newbie on that issue as well.

Thank you in advance for any pointers you can send my way.

Menachen