So are you using rebol/command with ODBC?
That is the only way I have talked to MS-SQL.
I always use somethign like this when talking to a MS-SQL server:
sql: {SELECT field1,field2 FROM table_A}
insert dbport sql
result-rows: copy dbport
The same thing works for mySQL also.
-----Original Message-----
From: Franck MARCIA [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 12:04 PM
To: [EMAIL PROTECTED]
Cc: Cindy Sassenrath
Subject: [REBOL] RE : MSSQL results
Nobody's got an answer?
Is there something like the "mydb_next_result" of PHP with Rebol?
Franck.
-----Message d'origine-----
De�: Franck MARCIA
Envoy�: lundi 30 septembre 2002 09:41
��: [EMAIL PROTECTED]
Objet�: [REBOL] MSSQL results
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.
--
To unsubscribe from this list, please send an email to
[EMAIL PROTECTED] with "unsubscribe" in the
subject, without the quotes.
--
To unsubscribe from this list, please send an email to
[EMAIL PROTECTED] with "unsubscribe" in the
subject, without the quotes.
--
To unsubscribe from this list, please send an email to
[EMAIL PROTECTED] with "unsubscribe" in the
subject, without the quotes.
