Thanks Myles - yes, it is in D5 - didn't spot it.
Bob
>
> From: Myles Penlington <[EMAIL PROTECTED]>
> Date: 2003/02/28 Fri AM 11:14:26 GMT+13:00
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Subject: RE: [DUG]: ADO and SQL Server Multiple result sets
>
> Use (This is in D6 - don't know about D5) - can't remember having used it
> myself from Delphi - but have used it from JScript.
>
> AdoDataset.NextRecordset()
>
> Myles.
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, 28 February 2003 11:10 a.m.
> To: Multiple recipients of list delphi
> Subject: [DUG]: ADO and SQL Server Multiple result sets
>
>
> Hi All
>
> I've just discovered that SQL Server allows stored procedures to return
> multiple result sets, as in
>
> CREATE PROC Multi AS
> SELECT * FROM Debtors
> SELECT * FROM Creditors
> Return 0
> GO
>
> In a quick test with D5 the 2nd result set is ignored - all I can see is
> Debtors. Has this been catered for in D6 or 7? If not, is there any way to
> get access to the 2nd result set?
>
>
> Bob Osborn
>
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
