Hi,

Thank for your advise. Most of the time, my client server
just hang up for reason not know to me, which my program
and data files are reside on which are causing all the
CDX files to be corrupted.

Could you kindly explain in more detail on
'putting the table and cdx on the readonly server plus
non-structure index and more coding alternatives.'
I like to know of better or alternative ways to
solve indexes problems.
Any advise is very much appreciated. Thank you.



>>Hi,
>>
>>My application run fine, but sometimes, my client server hang, causing
>>my application processing data to give error as it can't access the data files giving CDX problem.
>>
>>Is there any ways before my program process data, that I can detect this problem with CDX or DBF that I can auto do a reindex to solve the
>>problem. Any suggestions or advise on how to do it is very much appreciated. Thank you.
>
>I agree with Wayne...usually when I have indexes go bad, I don't even get any errors, I just get bad results with the data, so you can't trap anything for that. Here's a suggestion that works in some situations, if you're really having a lot of trouble: put the table and/or cdx in a readonly server directory. Errors will pretty much disappear.
>
>This also may mean a non-structural CDX, and more coding, but it may beat the alternative...