setfilter引號問題
string ls_ksmc
long ll_row
string ls_atb
ll_row = dw_2.getrow()
ls_ksmc = dw_2.getitemstring(ll_row,'bmbm')
ls_a = "sb_mxb.bmbm = ls_ksmc"
dw_1.setfilter(ls_a)
dw_1.filter()
從dw_2中得到字段bmbm，通過bmbm檢索dw_1的數據，結果報錯“expression is not valid”怎么改setfilter的引號啊，各位高手指點
------解決方案--------------------------------------------------------ls_a
tb = "sb_mxb.bmbm = 'ls_ksmc'"
------解決方案--------------------------------------------------------應該是這樣寫：ls_a = "sb_mxb.bmbm = '"+ls_ksmc+"'"
------解決方案--------------------------------------------------------
------解決方案--------------------------------------------------------string ls_ksmc
long ll_row
string ls_a
ll_row = dw_2.getrow()
ls_ksmc = dw_2.getitemstring(ll_row,'bmbm')
ls_a = "sb_mxb_bmbm = '" + ls_ksmc + "'"
dw_1.setfilter(ls_a)
dw_1.filter()
------解決方案--------------------------------------------------------或者這樣試試
string ls_ksmc
long ll_row
string ls_a
ll_row = dw_2.getrow()
ls_ksmc = dw_2.getitemstring(ll_row,'bmbm')
ls_a = "bmbm = '" + ls_ksmc + "'"
dw_1.setfilter(ls_a)
dw_1.filter()
------解決方案--------------------------------------------------------1.bmbm是不是字符型的，如不是請轉成字符型，函數string()
2.dw_1有沒有retrieve，沒有retrieve就沒有數據過濾了
------解決方案--------------------------------------------------------看下是不是引號寫錯了
------解決方案--------------------------------------------------------只要列的值不需要表的值看看
------解決方案--------------------------------------------------------要不然你不要帶參數進去，直接就來個具體的值看看。
------解決方案--------------------------------------------------------dw_result.setfilter("bmbm = '"+ls_ksmc+"'")