[fpc-pascal] how to use odbc Allow multiple statements

2010-06-10 Thread liuzg2
but can TSQLScript result as tdateset? 1: select top 1 * into #x from r_sale; select * from #x 2:declare @busno VARCHAR(10) select @busno='0001' CREATE TABLE #wareid .. select * from #wareid where bus...@busno ___ fpc-pascal maillist - fpc-pascal@l

Re: [fpc-pascal] how to use odbc Allow multiple statements

2010-06-10 Thread Michael Van Canneyt
On Thu, 10 Jun 2010, Graeme Geldenhuys wrote: Op 2010-06-10 08:23, Michael Van Canneyt het geskryf: Just use 2 TSQLQuery statements at once. Each will set up a connection to MySQL, as far as I remember. [...maybe he meant the following...] Is there a SQL Script component in SqlDB? So that

Re: [fpc-pascal] how to use odbc Allow multiple statements

2010-06-09 Thread Graeme Geldenhuys
Op 2010-06-10 08:23, Michael Van Canneyt het geskryf: > > Just use 2 TSQLQuery statements at once. Each will set up a connection to > MySQL, as far as I remember. [...maybe he meant the following...] Is there a SQL Script component in SqlDB? So that you can pass it a DDL script file which will c

Re: [fpc-pascal] how to use odbc Allow multiple statements

2010-06-09 Thread Michael Van Canneyt
Just use 2 TSQLQuery statements at once. Each will set up a connection to MySQL, as far as I remember. Michael. On Thu, 10 Jun 2010, liuzg2 wrote: how to use odbc Allow multiple statements Connection mssql ___ fpc-pascal maillist - fpc-pascal

[fpc-pascal] how to use odbc Allow multiple statements

2010-06-09 Thread liuzg2
how to use odbc Allow multiple statements Connection mssql ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal