string r1,r2
date day,ld1,ld2
long xs
r1=em_1.text
r2=em_2.text
ld1=date('"+r1+"')
ld2=date('"+r2+"')

delete from day_xs;
commit;

declare p cursor for
select buyer_uid,sum(d_sales)
from st_buyer_sale
where RUN_DATE between :ld1 and :ld2;

open p;

fetch p into :day,:xs;
insert into day_xs values(:day,:xs);

close p;
commit;
dw_1.dataobject="q_new"
dw_1.settransobject(sqlca)
dw_1.retrieve()





保存时报错 提示:非单组组函数

求解....

报错提示在where RUN_DATE between :ld1 and :ld2;
这一行

sum(d_sales)是计算st_buyer_sale 中d_sales这个字段在一段日期内的和

我加了group by 保存没问题了 但是运行的时候提示

database transaction information not available

call settrans or settransobject function....





string r1,r2
date day,ld1,ld2
long xs
r1=em_1.text
r2=em_2.text
ld1=date('"+r1+"')
ld2=date('"+r2+"')

delete from day_xs;
commit;

declare p cursor for
select buyer_uid,sum(d_sales)
from st_buyer_sale
where RUN_DATE between :ld1 and :ld2 group by buyer_uid;

open p;

fetch p into :day,:xs;
insert into day_xs values(:day,:xs);

close p;
commit;
dw_1.dataobject="q_new"
dw_1.settransobject(sqlca)
dw_1.retrieve() 郁闷...