It’s
simple enough. All my select executions check for multiple record sets and I simply collect an array of them:
DO WHILE oRS != NULL_OBJECT
IF oRS:State = adStateOpen
nRecs := oRS:RecordCount
AAdd(aResults, oRS)
ENDIF
oRS := oRS:NextRecordset(NIL)
ENDDO
Then you just operate on the open record sets. Oft times there can be several.