各位先進....
小弟寫了一個SQL的語法去選擇自己所想要的欄位...
可是系統偵錯在箭頭的那一行..
mysql = "SELECT KTTB09.KT_CNTY, KTTB05.KT_PHQ, KTTB05.KT_PST, KTTB11.KT_ODID, KTTB09.KT_PZONE, KTTB09.KT_TOWN, KTTB09.KT_VLGE, KTTB09.KT_ROAD, KTTB09.KT_SECF, KTTB09.KT_SECT, KTTB09.KT_LANEF, KTTB09.KT_LANET, KTTB09.KT_ALLYF, KTTB09.KT_ALLYT, KTTB09.KT_NOF, KTTB09.KT_NOT, KTTB09.KT_OFF, KTTB09.KT_OFT, KTTB09.KT_SCOPE FROM (KTTB05 INNER JOIN KTTB09 ON KTTB05.KT_DID = KTTB09.KT_DID) INNER JOIN KTTB11 ON KTTB05.KT_DID = KTTB11.KT_DID WHERE KTTB09.KT_CNTY='" & Combo1.Text & "'"
Set rs = New ADODB.Recordset
rs.Open mysql, cn, adOpenStatic
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
訊息為無一或多數值可以指定給????
如果減少選擇欄位即可顯示結果....可否告知要如何解決嬤..??