>Is there an explanation why RECCOUNT() doesn't return the right value in the following code ?
>
>

>create table t1 (f1 C(1))
>insert into t1 (f1) VALUES ("A")
>
>create table t2 (f1 C(1))
>insert into t2 (f1) VALUES ("B")
>index on f1 tag f1
>
>select "t1"
>scan
>	SELECT * FROM t2 WHERE f1 = t1.f1 INTO CURSOR tmp
>	? reccount()  && display 1
>	? _tally      && display 0
>endscan
>

>
>RECCOUNT() returns 1 while it is supposed to return 0. This problem occurs only if you create an index on f1 in table t2. Without the index, it returns 0.
>
>Thanks.

_TALLY should always be used since FoxPro will sometimes created another open instance of the table with a filter when creating the result set. In these cases the value returned by RECCOUNT() is the same as the original table.