as far as I know it really is impossible to have TWO or more recordsets active. As dbSelect() has no return value, assigning a name to each one is impossible.
But maybe you can try to put those dbSelect() statements into different scripts that you either call with "Run()" or that you include with "include" (I didn't test the last one so it's just a guess).
Hope it helps,
P.S.: probalbly you can put all SELECT- Statements into one large one (with the JOÌN- command from SQL, if necessary use aliases for the different column names) ????
[This message has been edited by Andy Maurer (edited 07-30-2001).]
I had some problems when I ran into this limitation as well. Since the language is so forgiving, and variables can be so loosely defined, I set up a few arrays to shuffle around record sets within the program. I realize that isn't the most efficient way, but I have more testing experience than development experience.
Every time I run into a coding limitation, I let the folks at Compuware know. They tell me that they log it, so maybe the developers of the tool will add the ability in the future.