Moving b/w recordsets after calling stored procedure
Posted on 2003-12-01
I have a stored procedure that returns a recordset and has an output parameter that I used to format the page.
Currently, I loop through the recordset's information, then call objRS.NextRecordset and check the value of the output parameter.
Ideally, I'd like to have the value of the output parameter before I loop through the recordset. Is there anyway to have the output parameter accessible before the recordset or is there a PreviousRecordset method?
Also, why do I have to call objRS.NextRecordset anyway since the parameter is part of the command object?