You can also use CONNECT DATABASE statement too. Of course the database must exist...

Jason

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
It was lacking CREATE DATABASE statement.

Thanks.

----- Original Message -----
From: Markus Ostenried
To: IBObjects@yahoogroups.com
Sent: Friday, February 20, 2004 12:28 PM
Subject: Re: [IBO] Problem with TIB_Script


At 12:11 Friday, 20.02.2004 -0300, you wrote:
>I'm using component TIB_Script and i have a problem when try to create a
>trigger.
>ERROR: Invalid CREATE, CONNECT or DROP DATABASE syntax.

First you're TIB_Script must have a TIB_Connection component assigned.
Then this IB_Connection must have set its property Connected := true or the
SQL of the IB_Script must first contain a CREATE DATABASE or CONNECT statement.

HTH,
Markus