>>>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 ?
>>
>>Pascal,
>>Records are still in buffer ?
>>Cetin
>
>Yes, is this the problem ? Browse, locate, etc ... them : yes, query them : no ??
SQL cannot access records in buffer.
browse, locate, seek, scan..endscan etc can work with buffered.
Cetin