Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird Index Problem
Message
 
To
27/03/2002 08:23:08
Jerry Brunet
Brunet Computer Systems
Canfield, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00637654
Message ID:
00638122
Views:
20
Jerry,

For your future reference, always, that is always, delete the index before you try any method of recreating it. Never use Reindex on an index that is giving errors as reindex uses the index header to determine what tags to build and if there are errors when using the index then it is likely the index header is bad.

Even Index on without killing the index file first is not dependable for a bad index as it marks the old tag as obsolete and creates a new one IN THE SAME file. If the file is corrupt, and it likely is when there are errors, then there is no guarantee that the index will use the correct tag within itself.

Bad index = kill the cdx and create a new one
Previous
Reply
Map
View

Click here to load this message in the networking platform