This is a known issue with VFP cursors. As far as I know, you cannot use SQL-SELECT statements with VFP cursors because it won't pick up changes made to records in the cursor. There are two work arounds that I know of:
1. Use VFP "regular" commands like SCAN/ENDSCAN, LOCATE, and so forth for this cursor.
2. Try using SELECT * FROM dbf('yourcursor').
>Strange problem here : a form with a updatable view ; if I browse this view's cursor from the datasession window I see records but when I do a 'select * from thatcursor' I have no records selected. (BTW : the records in the view where added to it manually, they weren't selected by the view's query, the problem seems only to happen in this case (added records))
>
>I have a similar behaviour with records deleted in the view which aren't ignored if a deleted() is used in the where clause of a select I try on the view.
>
>What's up here ?
Hector Correa