动态数据窗口的问题

[xxq1977]

string sqlselect,errmsg,sqlselect1,errmsg1
sqlselect="select cpbm,hzsl1=sum(zmsl) from rkdmxtb where rkd_rq between '12/26/2002' and '1/20/2003' group by cpbm"
sqlselect1="select cpbm,hzsl2=sum(sl) from ckdmxtb where ckd_rq between '12/26/2002' and '1/20/2003' group by cpbm"

dw_1.create(sqlca.syntaxfromsql(sqlselect,"style(type=grip)",errmsg))
dw_2.create(sqlca.syntaxfromsql(sqlselect1,"style(type=grip)",errmsg1))
dw_2.settransobject(sqlca)
dw_1.settransobject(sqlca)
dw_1.retrieve()
dw_2.retrieve()
1、动态数据窗口中是否可用变量啊，比如日期
2、动态数据窗口中的数据如何用getitenstring()函数取数？

[shahand]

1 可以
2 与普通数据窗口一致，列名为表的列名

[YewPu]

用if判断吧！

[heromei]

sqlselect="select cpbm,sum(zmsl) as hzsl1 from rkdmxtb where rkd_rq "