Skip to Content
0
Former Member
May 04, 2005 at 07:54 AM

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

17 Views

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.