Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate...
Message
De
23/10/2002 15:06:06
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
23/10/2002 15:02:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00714503
Message ID:
00714507
Vues:
15
>I am running into a problem that doesn't happen all the time. I have a form that has a grid. The tables are opened buffered and child records can be edited in the grid. The grid works somewhat like a spread sheet in that when a column item is changed, the total changes. Once all the changes have been made, the user clicks on a save button and a tableupdate is done to save the changes to the child table and then a requery is done to update the parent table with the totals. My problem is that, at times, the requery doesn't get all the changes to the child table when it tries to update the parent table with the results. I wonder if server load and server cache has anything to do with my problem as the requery is just a few lines after the table update in my code and that maybe the cache isn't saved quick enough before the requery takes place. Does a query operate on data stored on the server drive or on the users workstation cursors? Any ideas or thoughts as to how to find where my
>problem lies.
>
>Thanks in advance
>Ron

Postpone the parent-requery with a Timer. Thus, you will know whether it is, or isn't, a timing issue (there are also timing issues within VFP). Also, the application doesn't wait for the Timer - it continues executing. Thus, you won't lose any time waiting.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform