Hi!

tableupdate() has a parameter - when it is .F., data will not be saved when there are changes by another user (tableupdate() will return .F. in such case). You can even determine what data are changed: Use refresh() for current record in view to get the latest values from the server. Then loop through fields and compare oldval() with curval().

HTH.

>Hi,
>
>I wrote a program using odbc and remote views to connect to a database. The program has an unlimited number of users(multi user environment.) How can I prevent data inconsistency. On my findings, a user can update a record while another user is processing the same record. In this case, the 2nd user might have finished calculating the record before the other had updated it. Any suggestions, recommendations on how to minimize if not eliminate this problem?
>
>
>Thanks in Advance
>Mike Zapanta