740
社区成员
发帖
与我相关
我的任务
分享
ls_sql = dw_2.describe("datawindow.table.select")
if posa(ls_sql , "where") > 0 then
ls_select = lefta(ls_sql , posa(ls_sql , "where") -1)
else
ls_select = ls_sql
end if
ls_where = "where a.flid ='"+gs_flid+"' and a.ifenddate = 0"
ls_sql = ls_select+ls_where
ls_sql = dw_2.describe("datawindow.table.select")
if posa(ls_sql , "where") > 0 then
ls_select = lefta(ls_sql , posa(ls_sql , "where") -1)
else
ls_select = ls_sql
end if
ls_where = "where a.flid ='"+gs_flid+"' and a.ifenddate = 0"
ls_sql = ls_select+ls_where
if dw_2.setsqlselect(ls_sql) = 1 then
dw_2.modify("datawindow.table.updatetable = dangan")
dw_2.modify("xh.update = yes")
dw_2.modify("dang_mj.update = yes")
dw_2.modify("wjgh.update = yes")
dw_2.modify("dangxh.update = yes")
dw_2.modify("dangmc.update = yes")
dw_2.modify("fs.update = yes")
dw_2.modify("dangan_dzwj.update = yes")
dw_2.modify("xh.key = yes")
ll_rowcount = dw_2.retrieve()
if ll_rowcount > 0 then
cb_2.enabled = true
cb_3.enabled = true
cb_4.enabled = true
cb_5.enabled = true
end if
end if
end if
还是不行呀,字段xh是自增的。