求幫小弟我看下這段代碼幹嘛了
求幫我看下這段代碼幹嘛了.
Public Function ForwardRS(ssql As String, Optional Conn As Connection) As Recordset
Dim blNeedClose As Boolean
If Conn Is Nothing Then
Set Conn = New ADODB.Connection
Conn.CursorLocation = adUseClient
Conn.CommandTimeout = 300
Conn.Open connStr
blNeedClose = True
End If
If Conn.State <> adStateOpen Then Exit Function
Set ForwardRS = New ADODB.Recordset
ForwardRS.Open ssql, Conn, adOpenStatic, adLockReadOnly
If blNeedClose = True Then
ForwardRS.ActiveConnection = Nothing
Conn.Close
Set Conn = Nothing
End If
End Function
------解决方案--------------------
就是 创建数据库对象 然后用游标读取数据吧。
Public Function ForwardRS(ssql As String, Optional Conn As Connection) As Recordset
Dim blNeedClose As Boolean
If Conn Is Nothing Then
Set Conn = New ADODB.Connection
Conn.CursorLocation = adUseClient
Conn.CommandTimeout = 300
Conn.Open connStr
blNeedClose = True
End If
If Conn.State <> adStateOpen Then Exit Function
Set ForwardRS = New ADODB.Recordset
ForwardRS.Open ssql, Conn, adOpenStatic, adLockReadOnly
If blNeedClose = True Then
ForwardRS.ActiveConnection = Nothing
Conn.Close
Set Conn = Nothing
End If
End Function
------解决方案--------------------
就是 创建数据库对象 然后用游标读取数据吧。