>Is there any way to detect corrupt indices in foxpro dbfs ? I mean some corrupt tag in a cdx file
Not that I know of. I can see where this might be useful, to know whether you need to reindex. Reindexing requires exclusive access which may be difficult in a multiuser environment.
One useful approach for dealing with index corruption is simply to have a known good .CDX file available. This known good one does not even have to have any records. Just overwrite the suspect one with the known good one, and REINDEX.
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