>Hi,
> I am using table buffering in my application. Once I issue SELECT-SQL, why VFP try to locate the table from server again instead of the data buffered in local workstation? (The performance with buffering and not buffered is SAME)
>
>Please advise
>
>Thank you

In order to optimize a query, VFP will open the source files again in other workareas under new aliases. This is done so that it can use any index or create a new one if necessary and not screw up your current workarea.

Because of this, it uses the disk presence of the tables and not the memory buffered version you just modified. If you want to use the memory presence, you need to use xBase commands like SCAN/ENDSCAN, LOCATE or SEEK.

HTH.