Hi

Using tIB_Script I execute :

SET SQL DIALECT 3;
SET AUTODDL ON;

I then have a tIB_Script to create a DB :

CREATE DATABASE 'C:\DelphDat\sqldatafile\TEST1.GDB'
USER 'SYSDBA' PASSWORD 'masterkey'
DEFAULT CHARACTER SET NONE;
CREATE TABLE TESTTABLE (
F1 SMALLINT NOT NULL,
F2 SMALLINT NOT NULL,
F3 INTEGER );

If I run then script again, just changing line[0] to
CREATE DATABASE 'C:\DelphDat\sqldatafile\TEST2.GDB'

I get the error - 'Invalid Database handle - no active transaction'

My scripts IB_transaction property is <default>, since I cannot
assign a transaction / connection ( as I am creating a database ).

If I run the above mentioned process in IBConsole, I works fine.

Please advise

Thanks - Rod