Hi all, Can I run query and to retrive the rows count without cursor, or I must as following:
local itotal
selectdistinctidfrom mytable;
wherebetween(mytable.id,1583,1927);
and mytable.state=='NY'intocursor mycursor nofilter
itotal=reccount('mycursor')
myform.txt1.value=transform(itotal)
usein mycursor