select cCusCode,cCusName,cCusAbbName,cDCCode,cCCCode,cCusAddress,cCusEmail,cCusPerson,cCusPhone from Customer WHERE cCCCode='"+is_currNo+"' and cCuscode IN (select DWZD_DWBH from BL_DWZD)
以上陳述句是同一個資料庫中的判斷，現在表Customer 與表BL_DWZD分別存盤兩個資料庫中，請用怎么用事務把這個SQL改造一下
uj5u.com熱心網友回復：
同一服務器：select cCusCode,cCusName,cCusAbbName,cDCCode,cCCCode,cCusAddress,cCusEmail,cCusPerson,cCusPhone from Customer WHERE cCCCode='"+is_currNo+"' and cCuscode IN (select DWZD_DWBH from 庫名..BL_DWZD)
uj5u.com熱心網友回復：
dw_1.setsqlselect("select cCusCode,cCusName,cCusAbbName,cDCCode,cCCCode,cCusAddress,cCusEmail,cCusPerson,cCusPhone from Customer WHERE cCCCode='"+is_currNo+"' and cCuscode IN (select DWZD_DWBH from DATAMODEL..BL_DWZD)" )結果不正確uj5u.com熱心網友回復：
dw_1.settransobject(sql_u8)dw_1.setsqlselect("select cCusCode,cCusName,cCusAbbName,cDCCode,cCCCode,cCusAddress,cCusEmail,cCusPerson,cCusPhone from Customer WHERE cCCCode='"+is_currNo+"' and cCuscode IN (select DWZD_DWBH from DATAMODEL..BL_DWZD)" )
dw_1.retrieve( )
由于是在資料視窗中檢索的,這樣寫不正確
uj5u.com熱心網友回復：
建立個事務去連接DATAMODEL 然后 弄個資料視窗retrieve這個資料（select DWZD_DWBH from DATAMODEL..BL_DWZD） 然后取出這個視窗的數 再select cCusCode,cCusName,cCusAbbName,cDCCode,cCCCode,cCusAddress,cCusEmail,cCusPerson,cCusPhone from Customer WHERE cCCCode='"+is_currNo+"' and cCuscode IN這樣組合下吧
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/70839.html
標籤：數據庫相關
下一篇：求救，.bat腳本