Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View gets a different set of data at runtime
Message
De
13/06/2003 07:38:48
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00799690
Message ID:
00799711
Vues:
20
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
Fil
Voir

Click here to load this message in the networking platform