vba怎么取不到记录集的个数
相关语句如下:
Dim cn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim R As Integer
ConnectString = "DRIVER={SQL Server}; SERVER=192.168.0.1;UID=u1;PWD=u1; DATABASE=database2000"
cn.Open ConnectString
sqlstr = "select * from user_list"
Set rst = cn.Execute(sqlstr)
R = rst.RecordCount
1.为什么R总是等于-1呢?
2.如果user_list表中没有数据或没这个表,cn.Execute(sqlstr)是不是会出错?