In RDO I can do
for each rs in rd_conn.rdoresultsets
    rs.close
    set rs=nothing
next

I'd like to do the same thing,close all resultsets I have opened  during
the process, before I exit out from the program.
How do I do that in ADO?

Thanks

Grace

Sent via Deja.com http://www.*-*-*.com/
Share what you know. Learn what you don't.

ADO was designed as a very flat object model.  One of the main drivers
behind it was to create a thin data access model for the internet.  Within
this model, it is usually good to get a connection to the database as late
as possible and to release that connection as quickly as possible.
Therefore you would not keep a lot of connections and recordsets open in am
application.

So there is no strict hierarchy in ADO like there was in RDO and therefore a
recordsets collection does not exist.  You can create your own collection
object if you want to store all of the recordset that you have open and
delete them from the collection as you close them.

--
Matthew Arnheiter
Flash Creative Management
http://www.flashcreative.com