假设我将使用下面的子程序运行各种查询。每次都应该set
和close
recordset
吗?或者应该与我的连接(cn
)一起只设置和关闭一次?如果我关闭了连接,是否需要关闭我的记录集?
Sub QueryPC(ByRef ReturnArray() As Variant, COB As Date, PC As Variant, FileCode As String)
Dim srtQry As String, tmpArray() As Variant
Set rs = CreateObject("ADODB.Recordset")
srtQry = "whatever"
Set rs = cn.Execute(srtQry)
If Not rs.EOF Then
tmpArray = rs.GetRows: TransposeArray tmpArray, ReturnArray
Else
ReDim ReturnArray(0)
End If
rs.Close
End Sub