returning result sets from stored procedures 
Author Message
 returning result sets from stored procedures

Hi,

I use ADO to call SQL Server stored procedures.
Issuing a select statement in a stored procedure returns the result set to
ADO and this is the architecture currently used in our product. We have to
support sql 7 so using tables as output parameters is not an option.
Everything works fine except that now I have to call a stored procedure from
inside another stored procedure and use it's result set in but I don't want
to pass this result to the ADO caller (because both procedures issue a
select statement, the ADO caller will actually receive 2 result sets, which
is not exactly what I want.
Is there any thing to do to clear the first result set?

thanks !!1



Wed, 30 Jun 2004 01:11:08 GMT
 returning result sets from stored procedures

[posted and mailed, please reply in news]

Quote:

> I use ADO to call SQL Server stored procedures. Issuing a select
> statement in a stored procedure returns the result set to ADO and this
> is the architecture currently used in our product. We have to support
> sql 7 so using tables as output parameters is not an option. Everything
> works fine except that now I have to call a stored procedure from inside
> another stored procedure and use it's result set in but I don't want to
> pass this result to the ADO caller (because both procedures issue a
> select statement, the ADO caller will actually receive 2 result sets,
> which is not exactly what I want. Is there any thing to do to clear the
> first result set?

It sounds like you get some inspiration from this article of mine:
http://www.algonet.se/~sommar/share_data.html.

--
Erland Sommarskog, Abaris AB

SQL Server MVP



Thu, 01 Jul 2004 08:14:12 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. returning result sets from stored procedures

2. return result set from stored procedure

3. return result set from stored procedure

4. Return result set from stored procedure

5. Return result set from stored procedure, possible ?

6. Returning Result Sets from Stored Procedures?

7. Returning result sets from stored procedures...

8. Returning result sets in oracle stored procedure (OLEDB)

9. return multiple result sets from a stored procedure

10. Can't update result set returned from stored procedure using RDO

11. Returning result set from function to stored procedure is very slooooooooow

12. best way to return a paged result set from a stored procedure


 
Powered by phpBB® Forum Software