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