You can still use SQL Select with

WITH (BUFFERING = .T.)

>That must be it. The CA Cursor is buffered. I will change the approach and won't use the SQL Select. Thank you.
>
>>Buffering?
>>
>>>I have a strange case where SQL Select from a cursor does not find any records.
>>>
>>>Example:
>>>
>>>I have a cursor created with CursorAdapter that has one or more records (verified as follows). Then I try to select from it but nothing is found. Here is an example:
>>>
>>>

>>>select CaCursor
>>>browse  && shows that is has records
>>>select * from CaCursor where .T. into cursor C_temp
>>>if _tally > 0
>>>   *-- never gets here
>>>endif 
>>>select C_temp
>>>browse && shows no records.
>>>

>>>
>>>Why could this happen? TIA