>

>dStart = DATE(2010,3,4)
>SELECT * FROM Client WHERE Client.DateApp = dStart INTO CURSOR MyResult
>
>? RECCOUNT("MyResult")
>? _TALLY
>

>
>Given Client data of:
>
>

>ID                   DateApp
>1                    01/01/2010
>2                    01/28/2010
>3                    03/04/2010
>

>
>The two ?'s above would result in RECCOUNT() = 3 and _TALLY = 1 respectively given that VFP would optimize the SELECT by essentially doing a;
>
>

>USE Client AGAIN ALIAS MyResult
>SET FILTER TO DateApp = dStart
>

>
>If you add the NOFILTER option to the SELECT as in:
>
>

>dStart = DATE(2010,3,4)
>SELECT * FROM Client WHERE Client.DateApp = dStart INTO CURSOR MyResult NOFILTER
>

>
>then RECCOUNT() and _TALLY would be equal because the NOFILTER tells VFP NOT to do the USE ... AGAIN with a SET FILTER to get the results cursor.


ohh i see hmm. Didnt kno that...i normally tested reccount() by sayin if REccount()=0 that kinda way
but thanks 4 clearing up the syntax guess its still safe to use as long as i use nofilter