>>Hi, I have a C/S desktop application using VFP9 as front-end and SQL Server as back-end. It uses remote views and optimistic buffering for editing records.
>>
>>My problem is like this:
>>
>>User "A" reads a record from the database (with the remote view) and begins modifying the data without saving it, then any other user reads the same record from the database (also using a remote view), and makes modifications and saves them before user "A".
>>
>>Is there a way for user "A" to know if any other user modified the same record (the same or other fields), and for the application to know and notify the user of those changes? Then, user "A" decides whether or not to overwrite those previous changes.
>
>Check out these functions: GetNextModified(), GetFldState(), CURVAL(), and OLDVAL()
>
>Tamar

Thanks Tamar. Those functions just return the fields/records that were changed on my remote view, they don't tell me it some value changed on the server.