Hmmm... Warren said that a REINDEX brings the indexes back in synch.

Now a REINDEX effectively does an internal DELETE TAG ALL and then rebuilds indexes based on the TAG info saved before deleting it.
Since the index **IS** repaired by the REINDEX, why in the world would the other way provide any better result????

To me there is far too much FUD spead here about REINDEX. I'd bet that 99.9% of the time REINDEX works just fine.

Now, my only guess on this problem by now is that the .CDX inquestion is not a "structural" index, but I freely admit thatit is a VERY long shot indeed.



>I think Sergey's advice is good. Open Locations.dbf. In the command window, type LIST STATUS TO MyFile.TXT (this is your list of associated TAGS and their KEYs. Then [for each tag], DELETE TAG MyTag. Then Index (not reindex) each tag according to the KEY specifications in MyFile.TXT.
>HTH
>>All indexes are CDX's as the table name like location.dbf and location.cdx.