Close recordset

[JCP]

How can I detect if any recordset is open and then close it?
Is it possible to do this procedure?

I appreciate any suggestions.
Thanks
jcp

 

[Jamie Collins]

How can I detect if any recordset is open and then close it?

Detective work shouldn't be required. If your app 'owns' a number of
recordsets then it should know everything about them, including when
and how to close them. FWIW ADO is pretty good at automatically
closing recordsets when they go out of scope.

Jamie.

--

 

[JCP]

Hi jamie,
do you mean, we don't need to use rs.close or set rs=nothing?

Thanks a lot

 

[Pieter Wijnen]

Still a good practise to destroy objects when you're through with them

Pieter