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/

Reply via email to