>How can i detect the a particular table has corrupted index. Simly using the table does'nt fire the error numbers below.
>
>INLIST(tnerrornumber,19,114)
>
>what command will initiate vfp to return the error numbers above
These errors appear when the index no longer matches the table - this would mainly happen when your table structure changes, without having the index open. I believe this can only happen with temporary indices (IDX), or when you overwrite one of the two files (DBF vs. CDX).
A corrupted index is not so easy to detect. One thing you can do is reindex regularly, whether you detect corruption or not. Another option is write a program that sets a specific index and then loops through all the records. If you have SET DELETED OFF, and the index is not filtered, the loop should go through reccount() records. Watch out - if there really is corruption, this might become an endless loop.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
