Hi Everyone,

I have a recurring problem with a VFP8 app in which a user tries to update a datetime field and sporadically receives a "Index does not match the table" error. The problem has not been resolved by deleting the CDX file and recreating the indexes from scratch.

I've read the well documented threads here on the "non-bug" with this issue in which VFP8 reports index mismatches on very fast machines even when there isn't corruption in the index file. I've also read about the workaround involving the SYS(1104) command to clear the memory buffers.

That being said, I have two questions for anyone who can answer them:

1) Is this "non-bug" fixed in VFP9?

2) For the SYS(1104) workaround, should I just put it in my code before doing the REPLACE command on the datetime field and have it clear the memory buffers every time, or should I only do it in my error handler code after the initial REPLACE attempt errors out?

Thanks in advance,