>>So, RECCOUNT() returns the number of the records in the current area, which is the one of the result set. BUT, the result set may be only a filter on the real table, so, the RECCOUNT() may return in fact the number of records in the real table (similar to a table that has an active filter). If the result is a real cursor, RECCOUNT returns the same thing as _TALLY.
>
>I have NEVER seen or had this happen, and if it does I feel it is a bug.
>
>BOb
I've seen it happen on a number of occasions. Is it a bug? No, because it's by design in order to improve the performance of the query. Otherwise, you might get unacceptable performance.
George
Ubi caritas et amor, deus ibi est