This is a general foxpro question, sorry if this is a little off-topic.
How much trouble have other people had with table indexes?
My experience has been that indexes do get trashed, but when this happens it is due to a failed write operation, and the index (.cdx or .idx file) is inevitably truncated to zero when this happens.
Has anybody here seen cases where the index becomes inaccurate, but it isn't truncated to zero bytes?
The reason I ask, the system I adopted has a process which reindexes tables regularly. Since in Foxpro this requires USE EXCLUSIVE, this is a real problem in a high-traffic, multi-user system.
I'm not sure how much sense it makes, if indexes don't become corrupt without being truncated then it is just a waste.