>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~

In addition to Sergey's good advice - download #9840 offers some insight into Recordsets and recordset states.