Close recordset

J

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
 
J

Jamie Collins

How can I detect if any recordset is open and then close it?
Click to expand...

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.

--
 
J

JCP

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

Thanks a lot
 
P

Pieter Wijnen

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

Pieter
 
Top