PB修改數據窗口SELECT語句時出錯
fansa 2016-08-10 10:45:46 語句:
if gs_db="" or gs_dh="" then
messagebox("提示","單別單號不能為空")
else
gs_sql="select a.TB001,a.TB002,a.TB026,b.TA070,b.TA053,a.TB009,a.TB028,c.MA002,c.MA121,d.TC012 from EPSTB as a LEFT join EPSTA as b on a.TB001=b.TA001 and a.TB002=b.TA002 Left join COPMA as c on b.TA004=c.MA001 LEFT JOIN COPTC as d on a.TB004=d.TC001 and a.TB005=d.TC002 where a.TB001='"+gs_db+"' and a.TB002='"+gs_dh+"' and b.TA034='Y'"
messagebox("提示" , gs_sql)
dw_1.dataobject='label'
dw_1.setsqlselect(gs_sql)
dw_1.settransobject(sqlca)
// ls_ssss=dw_1.getsqlselect( )
// messagebox("提示" , ls_ssss)
// dw_1.setSQLSelect(gs_sql)
// dw_1.retrieve()
// ls_sql_s='datawindow.table.select="'+gs_sql+' "'
// dw_1.Modify(ls_sql_s)
sle_7.text=gs_sql
if dw_1.retrieve() < 1 then
messagebox("提示" , "未找到任何數據!")
end if
end if
、、、、、、、、、、、、、、、、、、
執行取得的SQL語句
select a.TB001,a.TB002,a.TB026,b.TA070,b.TA053,a.TB009,a.TB028,c.MA002,c.MA121,d.TC012 from EPSTB as a LEFT join EPSTA as b on a.TB001=b.TA001 and a.TB002=b.TA002 Left join COPMA as c on b.TA004=c.MA001 LEFT JOIN COPTC as d on a.TB004=d.TC001 and a.TB005=d.TC002 where a.TB001='B101' and a.TB002='20130601001' and b.TA034='Y'
在SQL平臺執行是沒有問題的,PB執行出錯:datawindow error
select error:attempt to bind to a non-existent column
難道不能用setsqlselect()