Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement