Hi Bhavbhuti,

you can use SQL in this case (prior to VFP9), but you need a little trick to include the new/updated records.

Before doing the SQL start a transaction, do a table update, do your SQL, then do a Rollback.



>Hi all
>
>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?