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

Michael Van Canneyt michael at freepascal.org
Thu Jun 10 10:09:20 CEST 2010



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 you can pass it a DDL
> script file which will contain many sql statements to setup a DB or upgrade
> an existing one?

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.



More information about the fpc-pascal mailing list