set order to lcKey=key(1) lcTag=tag(1) scan lcValue=eval(lcKey) if not indexseek(lcValue, .f., alias(), lcTag) wait window "scream" endif endscanThis should be reworked for a double loop (for all the keys), and it wouldn't give a thorough test, because for the keys with repeated values, any seek finds the first record with that value, doesn't guarantee to find them all. Since there's no way that I know of to retrieve the key value from the cdx and to be sure it's not coming from the dbf... can't think of a better test.
?HowIsTable("mytable")
Needs reindexing.
>In regards to http://fox.wikis.com/wc.dll?Wiki~PersistentIndexCorruption I remembered something I wanted to post a few years ago. I didn't bother because I did something pretty dumb by restoring a CDX, but not the corresponding DBF. So I figured, mea culpa and kept my mouth shut. ;)