I'm need to some expertise in the area an unknown number of ADO recordsets returned from a call to an SP.

How can I check for the validity of the last recordset without bombing out? Should I loop through the recordsets to determine the number of recordsets returned first and use the count? If so, how do I best handle this? Each recordset does contain a query name that tells us what the recordset will contain but the number of recordsets can and does vary.

We have a mix of FPW 2.6 and VFP applications that need to do this check.

Advise, please? Thanks in advance~