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()





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

求解....

SQL有错吧！！！你這個sun是統計誰的總數呢？

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

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

我估计你buyer_uid字段是多个值，而你sum（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() 郁闷...