how to use odbc Allow multiple statements Connection mssql

Just use 2 TSQLQuery will set up a connection to
MySQL, as far as I remember.

Michael.

Op 2010-06-10 08:23, Michael Van Canneyt het geskryf:

Just use 2 TSQLQuery 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 contain many sql statements to setup a DB or upgrade an existing one?

Regards,
- Graeme -

In that case, the answer is: yes there is: TSQLScript. It will parse the script and send the SQL statements one by one to the connection.

Michael.

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

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

Op 2010-06-11 03:50, liuzg2 het geskryf:

can TSQLScript result as tdateset?

As far as I know, from experience with a similar component not from SqlDB, such SQLScript components do not return a result. They are there to execute DDL-type scripts.

Regards,
- Graeme -