Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Theory of lost data
Message
 
À
17/08/1999 10:11:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00254303
Message ID:
00254516
Vues:
23
>Bruce,
>
>About the only other approach I'd think to suggest would be to close and reopen the tables.

Yes, I mentioned that as my last resort...it will certainly work, but has interface and performance issues.

>
>As others have noted FoxPro buffers its data and the FLUSH command, well, flushes *g* those buffers to disk. Again, as also noted, there is the intervening hardware/network issue though if the the data has been purged from the local machine to the server then the only issues to keep the data from being correctly saved would be a network failure, server failure or someone at the server unexpectedly shuts it down.

The question about FLUSH is, what is meant by "flushing to disk"? It may just mean the local copies in my theory, which is pretty much the same thing Tableupdate apparently does.

What I'll probably end up doing is opening SHAREd for most editing work, and the one heavy data-processing section of the process where EXCL is required, do a separate close, open EXCL , process, reclose, and reopen SHARED afterward. It will require a little interface work, but is the easiest way to resolve it I can see...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform