>>I have been experiencing difficulty with a FoxPro 2.6 application. Occasionally a user will run a screen and it will apparently 'hang'. I have found that reindexing the tables, which are accessed by the screen, seems to solve the problem. Only .CDX indexes are used.
>
>The problem is inevitable because of technical problem i.e. abnormal shutdown,
>
>>
>>What, if anything, can be done to stop this apparent 'corruption' of indexes?
>>
>>If I write a data maintenance procedure, is there a way to test for such 'corruption'?
>
>Depending on the index problem. Some could be fixed with REINDEX only; others needs to totally rebuild the index, as in delete the entire cdx file then rebuild all indexes again.
Jess,
Repeat after me.. NEVER USE REINDEX!! It is a carryover command from the DBASE days.. Instead, you should look at delete tag all and rebuild the indexes from scratch!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only