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