Question

PowerBuilder 中怎么样动态改变datawindow的sql语句？大家能不能给几个方法 谢谢·

我这里需要改成（where column=变量） 运行时提示sql语句旁边':'有错  帮个忙解决下啦各位高手  string new_sqlnew_sql = "SELECT T_jcbg.bh,T_jcbg.ks,T_jcbg.sjrq,T_jcbg.dd,T_jcbg.sjz,T_jcbg.jcxm,T_jcbg.xjs,T_jcbg.dw,T_jcbg.bz,T_jcbg.bgrq,T_jcbg.jyz,T_jcbg.hdz FROM T_jcbg WHERE T_jcbg.bh = :ls_bh"dw_1.setsqlselect(new_sql)dw_1.settransobject(sqlca)dw_1.retrieve()

Answer 1

语句的写法有问题。不能把变量包在引号里面，变量前面不用加“:”，而应该用“' ”
具体可以用两种方法，修改sqlselect语句或者使用setfilter
string ls_oldsql
string ls_newsql
ls_oldsql = dw_1.getsqlselect()
ls_newsql = ls_oldsql + " where t_jcbg.bh = '" + ls_bh + "'"
dw_1.setsqlselect(ls_newsql)
dw_1.retrieve()
dw_1.setsqlselect(ls_oldsql)
第二种方法我比较喜欢用
strign ls_filter
ls_filter = " t_jcbg.bh = '" + ls_bh + "'"
dw_1.retrieve()
dw_1.setfilter(ls_filter)
dw_1.filter()