Public Function GetRecordSet(Sql As String) As ADODB.Recordset
Dim StrCon As String
Dim StrSql As String
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim StrPath As String
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
StrCon = GetConStr
con.Open StrCon
Set rs = con.Execute(Sql)
Set GetRecordSet = rs
End Function我在调用GetRecordSet函数后,
set rs=GetRecordSet("sql")
rs.RecordCount返回的总是-1
为什么,怎么解决
Dim StrCon As String
Dim StrSql As String
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim StrPath As String
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
StrCon = GetConStr
con.Open StrCon
Set rs = con.Execute(Sql)
Set GetRecordSet = rs
End Function我在调用GetRecordSet函数后,
set rs=GetRecordSet("sql")
rs.RecordCount返回的总是-1
为什么,怎么解决
Set rs = con.Execute(Sql)
rs.CursorLocation=adUseClient
rs.open Sql,con
//rs.CursorLocation=adUseClient是con.CursorLocation = adUseClient
Set rs = con.Execute(Sql)
我也遇到相同问题,就写上面就好啦
rs.open strsql,pubconn,1,1