At 10:46 AM 10/04/2003 +0200, you wrote:

>Why does it work in IBAdmin then? Well, I guess it has enabled a kind of
>AUTO COMMIT
>on DDL statements.
>
>Try to put a COMMIT after *each* DDL statement and re-run the script and
>see if
>that helps.

In fact, if you start the DDL script with the statement
SET AUTODDL ON
or just
SET AUTO
then the engine will create one transaction for each DDL statement and
autocommit it for you. --- note, this only works for DDL statements.

Don't mix up DDL and DML - either complete the DDL first, before beginning
the DML; or split it into two scripts. You can "chain" scripts together
by making the last line of the script
INPUT 'C:\DATA\SCRIPTS\SCRIPT2.SQL'; <remember a CRLF>

However - I don't know whether this work with the TIB_Script component...

Helen