Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
You should check if REQUERY() command is executed (maybe by a timer?).
Anyway, you can take the view offline with CREATEOFFLINE() to a local folder, append records locally (without any interference with other user), bring it online with ONLINE clause and execute the TABLEUPDATE() command.
>Hi all:
>
>I have a weird problem which I shall describe as follows:
>
>1. I have an application where an employee (USER ID) enters his work report on a working day. That is done through a grid. The grid's data source is a local view, filtered on USER ID and WORK DATE. The local view in the form's data environment uses optimistic table buffering. The application was created using VFP 6 SP 4.
>2. Sometimes, in the middle of an editing session, the grid's contents shows the data for a different user that is using the application at the same time somewhere in the network. However, when I click Save (which does a table update) the correct records are saved (i.e., records for the correct USER ID and WORK DATE), and these are the data the user entered before the grid started to show someone else's data. In effect, there is no corrupted data that I have to fix.
>3. The problem with this is that the behavior is very unpredictable. It does not choose when, what filters (USER ID and WORK DATE), and what machine/OS. There is no specific pattern of behavior.
>
>I am now at a loss for workarounds/solutions. Any explanation on this one will be highly appreciated.
>
>TIA,
Précédent
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