Stored Procedure returns number of sets. How to handle them?

[Former Member]

Hi, i have stored procedure which returns number of sets ( i have 3 SELECT's in it)

How can using the following code (#C)

can retrieve all 3 result sets.?

oCommand = oRecordSet.Command;

oCommand.Name="myProcedure";

oCommand.Parameters.Item(1).Value=oBpId;

oCommand.Parameters.Item(2).Value=i;

oCommand.Execute();

while (oRecordSet.EoF==false)

{

<b>>>> Here I need to retrieve not the first one but all the sets</b>

oRecordSet.MoveNext();

}

thanks to everyone.

[Former Member]

Hi Oleksiy.

Put in your stored procedure sentences like

<i>set vble1 = Your first SQL Stament

set vble2 = Your first SQL Stament

set vble3 = Your first SQL Stament</i>

At the end just do <i>Select vbl1, vble2, vbl3</i> and in your source code <i>orecordset.fields("vble1").value</i> ....

Try it

Regards

Jai