怎樣獲得按計算字段標准分組的每一組的和.

[chinabluesky]

數据窗口語法為:
SELECT "dba"."trans"."storecode",
"dba"."trans"."tillid",
"dba"."trans"."txdate",
"dba"."trans"."postdate",
"dba"."trans"."txtime",
"dba"."trans"."txno",
"dba"."trans"."docno",
"dba"."trans"."voiddocno",
"dba"."trans"."txtype",
"dba"."trans"."txmsg",
'' as tender,
'' as currence,
0.00 as amt
FROM "dba"."trans"
WHERE ( "dba"."trans"."txtype" = '2' ) AND
( "dba"."trans"."txdate" = :ad_txdate )
因為txmsg含有currence 和amt 的數据,于是就每一行的currence 和amt 的數据都從txmsg 取出.然后按currence 分組對amt求和,我怎么直接得到每一組數值,望大蝦們幫組,在下感激不盡

[rock_csdn]

呵呵，是，谢了。callingda(林丁)　！

[rock_csdn]

使用任意分组内任一行的行号都可以取得分组带内的内容！

//假设你对amt的求和计算域命名为amt_sum
string ls_NameAmt = 'amt_sum'
long ll_row ,i
string ls_currence, ls_tmp
dec lde_amt[]

ls_currence = ''
for i = 1 to dw_1.rowcount()
ls_tmp = dw_1.getItemString(i,'currence')
if ls_tmp = ls_currence then continue
ldec_amt[upperbound(ldec_amt) +1] = dw_1.getItemNumber(i,ls_NameSum)
next

[雄关漫道真如铁，]

老兄, 你的程序是不是少了一句呀?
for i = 1 to dw_1.rowcount()
ls_tmp = dw_1.getItemString(i,'currence')
if ls_tmp = ls_currence then continue
ldec_amt[upperbound(ldec_amt) +1] = dw_1.getItemNumber(i,ls_NameSum)
ls_currence = ls_tmp // 少了這吧?
next