I never use this, but...
If You include CONNECT database ... ... ...,
in the script, before CREATE TABLE line script, i think.

Regards.

Edson Luis Gonçalez
Ribeirão Preto / SP / Brazil

----- Original Message -----
From: "rodbracher" <rod@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 10, 2002 1:45 PM
Subject: [IBO] Please reply !


> Hi
> Sorry to post this twice - but no reply a couple of weeks ago.
>
> 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
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.345 / Virus Database: 193 - Release Date: 09/04/2002