达人帮忙看下程序的语法错误,谢谢

来源:百度知道 编辑:UC知道 时间:2024/07/04 09:44:31
Dim rs As Recordset
Dim objrs As Recordset
Dim conn As Connection
Dim id
Dim lastID As String
Set conn = New Connection
Set rs = New Recordset
Set objrs = New Recordset
conn.ConnectionString = "driver={sql server};server=zhangh;uid=sa;pwd=;database=niss"
conn.ConnectionTimeout = 30
conn.CursorLocation = adUseClient
conn.Open
objrs.CursorLocation = adUseClient
objrs.Open "select * from gjsz", conn, 1, 3
If objrs.BOF Then
lastID = "0"
Else
objrs.MoveLast
lastID = Trim(objrs.Fields("id").Value)
End If
rs.Open "select * from view11 where c_doc_id > '& lastID', conn, adOpenKeyset"
运行后提示
实时错误'3709'
连接无法用于执行此操作。在此上下文中它可能已被关闭或无效。
错误在最后一行
帮帮忙啊

最后一句不对,应该是
rs.Open "select * from view11 where c_doc_id > " & lastID, conn,3,1

Rs.Open "select * from view11 where c_doc_id > '& lastID', conn, adOpenKeyset"
改成
Rs.Open "select * from view11 where c_doc_id > '& lastID & "', conn, adOpenKeyset"

conn.ConnectionString = "driver={sql server};server=zhangh;uid=sa;pwd = '';database=niss"

rs.Open "select * from view11 where c_doc_id > '" & lastID & "'", conn, adOpenKeyset