>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 S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."