My question is more for my general understanding
If I open and view a table using a SQL string like this
gstrSQL1 = "SELECT * From Consignors ORDER BY [Last Name],[First Name];"
Set rsRs1 = gSequelDB.OpenRecordset(gstrSQL1, dbOpenSnapshot)
I know I have to close it with code like this after all my viewing of the records is complete
rsRs1.Close
Set rsRs1 = Nothing
Not for the part I not sure about
If I use a SQL string like this to update a record in the table do I have to close it as above or is the operation completed with the update?
gstrSQL1 = "UPDATE Users SET Password = 'AutoLogonNo' WHERE RecordID = 1"
gSequelDB.Execute gstrSQL1, dbSeeChanges
Thank you
Mike
If I open and view a table using a SQL string like this
gstrSQL1 = "SELECT * From Consignors ORDER BY [Last Name],[First Name];"
Set rsRs1 = gSequelDB.OpenRecordset(gstrSQL1, dbOpenSnapshot)
I know I have to close it with code like this after all my viewing of the records is complete
rsRs1.Close
Set rsRs1 = Nothing
Not for the part I not sure about
If I use a SQL string like this to update a record in the table do I have to close it as above or is the operation completed with the update?
gstrSQL1 = "UPDATE Users SET Password = 'AutoLogonNo' WHERE RecordID = 1"
gSequelDB.Execute gstrSQL1, dbSeeChanges
Thank you
Mike
