Stored procedure - how to view 2nd result set (MSSQL) ? - Thread - go-pugleaf

Thread View: borland.public.cppbuilder.database.ado

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Ondrej Gratz Thu, 19 May 2005 21:33

Stored procedure - how to view 2nd result set (MSSQL) ?

#816

Author: Ondrej Gratz
Date: Thu, 19 May 2005 21:33

14 lines
1452 bytes

Hello,

  could anyone explain how to open 2nd recordset that stored procedure 
returns ?
I am using MSSQL Server and ADO components (C++ Builder, of course).

For example sp_helplogins (in master database) returns 2 recordsets as 
you can see in MS SQL Query Analyzer (and as the documentation states). 
I'm able to open the first one (using TADOQuery or TADOStoredProc) but 
how can I switch to 2nd ?

Thanks for your replies.
Sincerely
Ondrej Gratz

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads