Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual FoxPro 5.0 and Indexes not being updated
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00725252
Message ID:
00725471
Views:
12
a reindex uses index info from the table header. If this is corrupt the only way to fix is the DELETE TAG ALL and create the indexes from scratch using INDEX ON ...TAG... You have to have exclusive use to REINDEX so you may as well go the DELETE TAG ALL route to see if this fixes your problem.

>A simple reindex will correct the index issue. The application is in a multi-user environment and requring exclusive access to the file for adding a location would be difficult. We have a pack and reindex routine that issues a pack and then a reindex on all tables that will bring back any location that has been added and lost. I found another way to get the index back and that is to recompile the database container. The application has gone through many generations and conversions to get the data back to into the new release and the indexes have been created again which does correct the problem then until someone adds a new location and then losses it because the index doesn't get updated. The application and Visual FoxPro doesn't detect that the index is bad giving any error messages.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform