This is part of the rushmore tech I believe it basically changes the order of the table and hides the records you dont want to see. However the record count would still be the same. You can do two things
1. Use the _Tally right after the Sql statment and store the results in a var.
2. add a .f. to the SQL statment ie
Select wname,wday, .F. From workday Where wday = date() ;
And wname <> "blank" Into Cursor tmp
# 1 is faster #2 creates a new table with the records in the SQL filter.
Ron
>Dear all ,
> I'm facing a problem which make me crazy .
> I use a SQL command :
>
> Select wname,wday From workday Where wday = date() ;
> And wname <> "blank" Into Cursor tmp
>
> The totalrec of workday is 4 ,and the totalrec of tmp is 2
> But when I do that :
>
> Select tmp
> i = reccount()
>
> The value of i is 4 .
> Do you know why ?