Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate...
Message
From
23/10/2002 15:06:06
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
23/10/2002 15:02:24
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00714503
Message ID:
00714507
Views:
14
>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform