[REBOL] MSSQL results

From: fmarcia:marcopoly at: 30-Sep-2002 9:41

Hi all,

I'm trying to retrieve several sets of data from an unique stored
procedure.

For example, the following stored procedure:
CREATE PROCEDURE getOrder @MY_ID int
AS
SELECT * FROM orders where order_id = @MY_ID
SELECT * FROM orders_details where order_id = @MY_ID
GO

called by: insert command "getOrder 1234"

just returns the first set of data.

Is there a way to retrieve the two sets?

Franck.

[1] · 2 · 3 · 4 · 5 ... 13 · 14 · 15 · 16 · 17 · See whole thread