My first suspition would be a corrupted index.

>Hello,
>
>I am ditributing a vfp 7.0 application, and i stumbled accross a very weird phenomena.
>
>On some computers some sql-statements aren't processed correctly, giving the wrong results.No errors or anything else, just the wrong results.
>
>On other compuers however, the code just runs fine.
>Trying to pinpoint the problem, i discovered that after installing VFP 7.0 on computers that show that erractic behaviour, the code runs perfect. after uninstalling the VFp 7.0 on those computers, they stay running perfectly,and processing the queries correctly.
>
>Except the exe-file of my application, i am also distributing msvcr70.dll (version 7.0.9111),vfp7renu.dll (version 7.0.0.9262),vfp7r.dll (version 7.0.9262)
>
>This is a very annoying problem since i have no way of being certain wether a installation will run correctly,and the user is quiet unware of the fact that the querie result is wrong (or he should check every record of the result wether it matches the conditons), since no error message is generated.
>
>Does anybody else ever saw this behavior? Or can someone tell me witch files vfp7.0 installs and does not remove after uninstalling. probably some .dll is updated or something like that
>
>I know this problem sounds very strange, but i am working for days on it now, and i can assure that it realy is as described,and it's driving me nuts, since there isn't much for me to go on (after all, even debugging is impossible, since the problem disappears after i install VFP7.0 on the pc.)
>
>Any help, any hint would be very much appreciated.
>
>Vincent