Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Turn Off VFP Caching? (Get Fresh Data)
Message
 
To
28/12/2008 13:10:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01369882
Message ID:
01370098
Views:
15
using buffered tables in dataenvironment, i found a tablerevert to refresh data

>Is there a way to force VFP to go back to the underlying data for a SQL-SELECT rather than using its cache?
>
>In a form, before saving a row, I have to check values in other rows of the same table to see if a value in a certain column has changed since the form opened. The problem is that VFP apparently has the data in its cache so it never goes back to the original data. I tried USE AGAIN but this just used the old (cached) data. I cannot close the table and reopen it because it is the primary table for this form. TIA.
Previous
Reply
Map
View

Click here to load this message in the networking platform