I know this is a really old message, but I was having the same problem today in a VFP 8 app and found your problem and consequently the pre-VFP9 solution to my problem. (I can not use VFP9 on this app yet.) Anyway, the good news is you can now SELECT against buffered data in VFP 9 --
SELECT ... FROM ... WITH (BUFFERING = .T.) WHERE ...
>Hi,
>
>I have a local view (lv_diario), buffering 5.
>
>And I got different results if I do,
>
>SELECT SUM(field) TO sfield FROM lv_diario INTO CURSOR query1
>
>(query1.sfield)
>
>and,
>
>SUM field TO sfield
>
>When I adding records to the view, everything is Ok, I get these results only modifying existent records and changing the "field" field.
>
>Any suggests? What I'm doing wrong?
Mark McCasland
Midlothian, TX USA