>I recently wanted to do a SELECT-GROUP BY for summing all the items in a Remote View which is Table Buffered. I never got any records, but I can successfully browse the same RV and see the details. I tried to DBF("RVName") in the FROM of the SELECT but then it could not find the .tmp file.
>
>Please advise on how can I do so without a SCAN and an array?
It's possible to query buffered records in VFP9 with new
WITH (BUFFERING = .T.) clause. In previous versions you can use non-SQL commands only.
--sb--