>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao