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.