In fact, it works nice with your approach. The problem is that I will have to rewrite all my stored procs and that I loose the logic "from 1 statement to several dataset".
I'm going to try another approach: contact RT support. Franck. -----Message d'origine----- De�: Vos, Doug [mailto:[EMAIL PROTECTED]] Envoy�: mercredi 2 octobre 2002 14:40 ��: '[EMAIL PROTECTED]' Objet�: [REBOL] Re: RE : Re: RE : MSSQL results So what about another approach where you set up two ports: sql-A: {select top 1 * from customers} sql-B: {select count(*) nb from customers} insert dbport-1 sql-A insert dbport-2 sql-B result-rows-A: copy dbport-1 result-rows-B: copy dbport-2 This seems like it would work OK. Not familiar with your situation... What do you lose from this approach? -DV -----Original Message----- From: Franck MARCIA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 4:09 AM To: [EMAIL PROTECTED] Subject: [REBOL] RE : Re: RE : MSSQL results Thank you for your answer, Doug, Yes, I'm using ODBC to talk to MS-SQL. But if you use something like: sql: { select top 1 * from customers select count(*) nb from customers } insert dbport sql result-rows: copy dbport You can't retrieve the second set of data. And that's my problem. Franck. -----Message d'origine----- De�: Vos, Doug [mailto:[EMAIL PROTECTED]] Envoy�: mardi 1 octobre 2002 22:40 ��: '[EMAIL PROTECTED]' Objet�: [REBOL] Re: RE : MSSQL results 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. -- 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.
