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

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