Article View: borland.public.cppbuilder.database.ado
Article #816Stored procedure - how to view 2nd result set (MSSQL) ?
From: Ondrej Gratz
Date: Thu, 19 May 2005 21:33
Date: Thu, 19 May 2005 21:33
14 lines
1452 bytes
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
Technical Details
Message-ID:
<428d0634@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,ba7402d4dced8679,start X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Thu, 19 May 2005 23:33:35 +0200 From: Ondrej Gratz <gratzo@atlas.cz> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.ado Subject: Stored procedure - how to view 2nd result set (MSSQL) ? Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 0520-3, 19.05.2005), Outbound message X-Antivirus-Status: Clean NNTP-Posting-Host: 147.229.202.109 Message-ID: <428d0634@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1116538420 147.229.202.109 (19 May 2005 14:33:40 -0700) Lines: 14 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail