>I have an application on site with approx 25 users. Application is in VFP3, neither data nor application has changed for sometime.
>
>However in last couple of weeks keep getting problems with records that are not correctly in the index. What I mean by that is browse natural order all records fine, set order to IndexA record in not in order, key runs something line 101,102,105,103 etc. Set order to IndexB and record is fine.
>
>I do a simple copy to, delete, append from and record takes it's rightfull place in index.
>
>Any ideas what might cause this all of a sudden?
>
>
>
>Gary.
>
>PS. We have done a full pack on all tables but problem is still occuring.
PACK and/or REINDEX cannot fix all possible index corruptions. If corruption is happening repeatedly then try one of the two following approaches:
1. DELETE TAG ALL, then manually recreate the index tags. The downside to this is that if you have relations etc. set in a .DBC this will break them.
2. If you have a KNOWN GOOD copy of the .CDX file from a backup (even years old would be OK, or from your development system), you could overwrite the production .CDX file with the backup, then REINDEX to bring the index up-to-date. This avoids problems with breaking database relations etc. but you have to be very sure your backup is itself not corrupted. Corruption can exist for some time before manifesting itself in obvious symptoms.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up