There is no direct way of locking it when you are going through ODBC. However, depending upon how critical it is to lock the record, you can create your own locking mechanism.

Here is what I did for one of my app.

1. Add a column in the table. 1. cLockByUserId

2. To lock the record, update cLockByUserId with id of user logged.

3. Check against these fields to see if the record is locked or not.

4. Clear out cLockByUserId to unlock the record.


>I am using VFP7. I am very heavy on remote views for table updating. Is
>there a way to lock a row/record (such as customer record while entering sales orders).
>
>Sincerely,
>
>Raz