TMSStoredProc AND OpenNext
Posted: Fri 29 Sep 2006 00:31
Hi, I'm using SDAC 2.30.0.7 for Delphi 6 AND MS SQL Server 2000.
I need to get all recordsets from my stored procedure.
CREATE PROCEDURE [dbo].[MY_STOREDPROCEDURE]
@vd1 AS datetime,
@vd2 AS datetime
AS
SELECT Name FROM Users WHERE date = @vd1
SELECT ID, Name FROM Users WHERE date = @vd2
GO
How can I get each result into diferent dataset ?
Thank's a lot!
Márcio Vinícius
I need to get all recordsets from my stored procedure.
CREATE PROCEDURE [dbo].[MY_STOREDPROCEDURE]
@vd1 AS datetime,
@vd2 AS datetime
AS
SELECT Name FROM Users WHERE date = @vd1
SELECT ID, Name FROM Users WHERE date = @vd2
GO
How can I get each result into diferent dataset ?
Thank's a lot!
Márcio Vinícius