Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Flushing data to the tables
Message
De
01/08/2001 13:50:48
Walter Meester
HoogkarspelPays-Bas
 
 
À
01/08/2001 12:35:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00538379
Message ID:
00538425
Vues:
17
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,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform