Dim rs As New ADODB.Recordset和
Dim rs As ADODB.Recordset
Private Sub Form_Load()
set rs=New ADODB.Recordset
End Sub这两种用法有什么区别?
Dim rs As ADODB.Recordset
Private Sub Form_Load()
set rs=New ADODB.Recordset
End Sub这两种用法有什么区别?
调试欢乐多
时才建立这个记录集对象而Dim rs As New ADODB.Recordset在定义这个对象时就建立了是个合理分配内存的问题
用这段代码:
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
rs.open
End Sub
时,在退出窗体进一定要 set rs=nothing ,否则再次打开时会提示出错,
如用下面的代码则不会:
Dim rs As ADODB.Recordset
Private Sub Form_Load() rs.open
End Sub
是不是 Dim rs as new ADODB.Recordset 定义的是公用的对象