>Hi Fabio,
>
>Just an FYI, When runnig under VFP9, the new -1 option for the second parameter on the set refresh command does not solve this problem either.
>
>This is really crazy, there has to be a way to get SQL Select results directly from the database table regardless of what exists in other private data sessions!

Alec,
I was 99% sure of this.
If VFP in a multiusers ambient is used,
the operation is corrected if it is not verified if it it is effectively.
Therefore, if not controls the temporal correctness, then VFP works and you can work calmly;
the world is full of illusions.

I use MS SQL as shared data area, and all the VFP tables are opened in exclusive way.

Fabio