>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 ?
Your cursor is actually a simple filter of the WorkDay table - you need to force the SQL Select to create a separate, temporary table. Try adding the NOFILTER clause to the end of your SQL Select, or add a low-overhead but non-Rushmore optimizable cndition to the WHERE clause. Using NOFILTER is preferable.
> Thanx