Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupt CDX suddenly
Message
De
03/11/2004 11:50:18
 
 
À
03/11/2004 11:37:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 3
OS:
Windows '98
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00957602
Message ID:
00957682
Vues:
17
>>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
Fil
Voir

Click here to load this message in the networking platform