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/
