SET SQLBUFFERING ON
That's been my default for years. When do you want to select against a CA alias and get what you don't see?


>Thank you.
>
>>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