Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupt CDX suddenly
Message
De
03/11/2004 12:13:56
 
 
À
03/11/2004 11:50:18
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:
00957707
Vues:
16
Copy that, Gary. I haven't read that book. All the same, HAVE you bloody well tried reindexing?!!! :-))
Even as a first resort? Who knows what weird and wonderful things go on behind the scenes in FP commands like PACK. Sergey does :-)

Cheers

Terry

>>>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.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform