Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
>>Well that's news to me. I thought Pack just permanently removes rec's >>marked as deleted. If that's the case, and you haven't reindexed, then you >>WILL get the same indexing problem everyday. 'sup to you
My understanding is that pack does the following
COPY TO WITH PRODUCTION FOR !DELETED()
DELETE FILE
RENAME TO
Therefore it is mightier that the REINDEX!
The Hackers Guide to VFP7 states:
"PACK permanently removes all marked records. What it actually does is copy all the unmarked records into a new file and then rename the new file. (The table is also reindexed.) Because PACK does this behind the scenes, there is a small chance for data loss if your system crashes during a PACK."
Regards
Gary.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement