我遇到如下问题:
Dim rst As New adodb.Recordset
Set rst = ReadTQStyle() 'ReadTQStyle函数返回类型为recordset
Debug.Print rst.RecordCount '报错:对象关闭时,操作不允许
Dim rst As New adodb.Recordset
Set rst = ReadTQStyle() 'ReadTQStyle函数返回类型为recordset
Debug.Print rst.RecordCount '报错:对象关闭时,操作不允许
Dim strSql As String
strSql = "SELECT * FROM YourTable WHERE con..."
On Error Resume Next
rs.Open strSql, cn, 1, 3
If Err.Number <> 0 Then
'MsgBox "应用程序出错,错误提示:" & Err.Description
Exit Function
End If
Set ReadTQStyle= rs.Clone
rs.Close
End Function
Dim strSql As String
strSql = "SELECT * FROM YourTable WHERE con..."
On Error Resume Next
rs.Open strSql, cn, 1, 3
If Err.Number <> 0 Then
'MsgBox "应用程序出错,错误提示:" & Err.Description
Exit Function
End If
Set ReadTQStyle= rs.Clone
rs.Close
End Function
Dim strSql As String
strSql = "SELECT * FROM YourTable WHERE con..."
On Error Resume Next
objRs.Open strSql, cn, 1, 3
If Err.Number <> 0 Then
ReadTQStyle=false
else
ReadTQStyle=true
End If
End Function
还有一种可能就是你的记录集打开方试如果不是1,1那rst.RecordCount 这个属性就会是-1
函数F8单步调没问题
返回值也不用写rs.clone,直接Set ReadTQStyle=rs就可以了。