[REBOL] RE : Re: RE : MSSQL results
From: fmarcia:marcopoly at: 2-Oct-2002 10:09
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=A0: Vos, Doug [mailto:[doug--vos--eds--com]]
Envoy=E9=A0: mardi 1 octobre 2002 22:40
=C0=A0: ['rebol-list--rebol--com']
Objet=A0: [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.