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

[REBOL] Re: RE : Re: MSSQL results

From: rebol:optushome:au at: 2-Oct-2002 23:28

I haven't got REBOL/Command on this machine so I'm just going from memory here. These are two separate (unrelated & unjoined) SQL statements, they should be inserted and retrieved separately. The driver returns 1 recordset (multiple records) per executed SQL request, not multiple recordsets. (some languages have wrapper objects that do this for you) (I'm surprised you didn't get an error, some/most ODBC drivers would report a Syntax error for two separate Select statements in one string, if they weren't joined or nested. e.g conn.execute() under ASP does) If you really want to emulate returning two or more recordsets in the totals block you could do something like this. (not tested) return-recordsets: func [ db-port [port!] "DB Command Port" SQL-Statements [block!] "Block of SQL statement strings" /local datasets ][ datasets: copy [] for each SQL SQL-Statements [ insert db-port SQL append/only datasets copy db-port ] datasets ] ; --- Run the function SQL-Cmds: [{select count(*) from first_table} {select count(*) from second_table} ] totals: return-recordsets db-command-port sql-cmds Cheers, Allen K