Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Michel,
There are two issues possible here.
1. Non-commited write buffers. These are rare and can be solved with a FLUSH.
In a network multi-user environment updates are immediately written to disk and a flush typically not needed.
2. Dirty read buffers. though the changes are written to disk, another instance of VFP may hold read buffers of that exact portion of the table that has been changed. At Default the buffers are refreshed at an interval of 5 seconds, but can be adjusted with SET REFRESH. To immediately refresh the buffers you can LOCK the table, a random record or table header to force a refresh.
HTH,
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only