我有一段用VB寫的小程式
Set Cn = New ADODB.Connection
Set Rs = New ADODB.Recordset
Cn.ConnectionString = SQL_String
Cn.Open
Rs.CursorLocation = adUseClient
Rs.Open "SELECT * From TEST WHERE [Number] >='" & AA & "ORDER BY [Number]", Cn, adOpenDynamic, adLockOptimistic, adCmdText
Run 時總是當在上面一行,不知道 Rs.Open 的語法那裡錯了!!
Set Cn = New ADODB.Connection
Set Rs = New ADODB.Recordset
Cn.ConnectionString = SQL_String
Cn.Open
Rs.CursorLocation = adUseClient
Rs.Open "SELECT * From TEST WHERE [Number] >='" & AA & "ORDER BY [Number]", Cn, adOpenDynamic, adLockOptimistic, adCmdText
Run 時總是當在上面一行,不知道 Rs.Open 的語法那裡錯了!!
全站熱搜
留言列表