Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP killed indexes
Message
From
24/08/1998 13:56:21
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00129087
Message ID:
00129398
Views:
19
>Jerry,
>
>You can agree or not as you chose, but the fact remains that REINDEX uses the CDX header record to determine what to do. If the index is corrupt, then the header may also be corrupt and REINDEX will only recreate a corrupt index file for you.
>
>The only way to insure that the resulting index is intact is to DELETE TAG ALL and then rebuild each tag with INDEX ON ..., using REINDEX may work 9 out of 10 times, but that 10th time will kill you.
>
>I only use reindex from the command window when I know that I can recreate the indexes manually if I need to.
Thank you, Jim.
I think you right about possible corrupiton CDX files and I even suspect that this happens when I am trying to modify index from VFP(for example, primary type from regular) and then FPD does not know how to handle it.
Jerry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform