>CREATE CURSOR TEST (b B DEFAULT 0.1,n N(18,4) DEFAULT 0.1,y Y DEFAULT $0.1) >FOR I=1 TO 10000000 > APPEND BLANK >NEXT >SELECT ROUND(SUM(b),4) sb,sum(y) sy,sum(n) sn FROM test INTO CURSOR result > >? TRANSFORM(sb+0.000000000000000) >? sn >? sy >>
CREATE CURSOR TEST (Amt i,b B(5),n N(18,5),y Y) for ix=1 to 100 insert into test values (ix,ix/100000,ix/100000,ix/100000) EndFor SELECT sum(amt) amt,sum(b) sb,sum(y) sy,sum(n) sn ; FROM test ; INTO CURSOR result ? amt, sb, sn, syIOW we're just wasting time.