Hi!

You cannot lock records through ODBC. Just check if record is modified by another user. If yes, ask the user to overwrite changes or not, maybe even show to use which data changed. Take a look to help to functions OldVal() and CurVal().

>Hi,
>
>Any one knows how to lock a record in remote views while the record is being edited by a user?
>
>Im having problem on record updating, the case is one user tries to edit a record while the another user is trying to delete the record. This case is quite tedious for data consistency. It is a critical issue particularly on processing of transactions...
>
>
>Thanks in advance.
>Mike