Can I retrieve all recordsets from a collection?
Posted on 2002-06-14
I wonder if it is possible to retrieve all recordsets by looping in a collection. A bit like:
For each rsTest in Recordsets
I've tried the code above and this one:
for each rsTest in cnMyConnection.recordsets
But it told me "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."
What I want to do is a loop that get all my recordsets, close them and set them to nothing automatically.
(I'm maintaining a site where recordsets are not closed explicitly and typing them all will be a very big job!)