Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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.