>>>Hi,
>>>
>>>It seems to me that I cannot rely on using RECCOUNT() to report number of records in a cursor (created with SQL Select) unless I use NOFILTER or READWRITE. That is, in my test, RECCOUNT() often returns number of records in the FROM table of SQL Select instead of the cursor. Is this correct?
>>
>>Yes. Use _TALLY to return the correct number.
>>
>>See http://berezniker.com/content/pages/visual-foxpro/queries-and-filtered-cursors for explanation of RECCOUNT() behavior.
>
>Thank you.

You're welcome.