>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 ?
Thanks hector,
as I said to Cetin already : after 2 years using VFP : didn't know about this :-(
Pascal.