Closing recordset object
-
Hello I have a small question. Do i need to call the Recordset.Close before i set it to nothing? Or the destructor will close it? Set oRsAdmin = oDb.Execute("SELECT * FROM tbAdmin " & _ "WHERE User = '" & UserId$ & "'") oRsAdmin.Close Set oRsAdmin = Nothing OR Set oRsAdmin = Nothing Thank you Ilya :confused:
-
Hello I have a small question. Do i need to call the Recordset.Close before i set it to nothing? Or the destructor will close it? Set oRsAdmin = oDb.Execute("SELECT * FROM tbAdmin " & _ "WHERE User = '" & UserId$ & "'") oRsAdmin.Close Set oRsAdmin = Nothing OR Set oRsAdmin = Nothing Thank you Ilya :confused:
-
Hello I have a small question. Do i need to call the Recordset.Close before i set it to nothing? Or the destructor will close it? Set oRsAdmin = oDb.Execute("SELECT * FROM tbAdmin " & _ "WHERE User = '" & UserId$ & "'") oRsAdmin.Close Set oRsAdmin = Nothing OR Set oRsAdmin = Nothing Thank you Ilya :confused:
I think it's closed automatically !!