Hi Tamar,

I do the same - mostly. There is a problem the way SELECT SQL end SET FILTER deal with the "==" operator.
Since I do not like to deal with the SET operators (ANSI??) I use LIKE instead.


Agnes


>>Hi all,
>>Can I run query and to retrive the rows count without cursor, or I must as following:
>>

>>local itotal
>>select distinct id from mytable;
>>	where between(mytable.id,1583,1927);
>>	and mytable.state=='NY' into cursor mycursor nofilter
>>itotal=reccount('mycursor')
>>myform.txt1.value=transform(itotal)
>>use in mycursor

>
>You could send the result to an array instead, and use ALEN() or _TALLY to see how many rows.
>
>Tamar