Am I right in assuming that if I have a method that connects to a database, reads records into a recordset and then passes that recordset to a calling process, the recordset that is in the method is automatically closed as on return the method loses scope? This is what I am reading in the docs but not 100% sure.
So then the only recordset I actually need to close is the one I setup to receive the recordset?
For example
GetData is the method that created the recordset
Dim rs As Recordset = GetData
…
rs.close
Should I also add
GetData.Close
To be safe?