Subject Re: [IBO] creating a new database
Author Paul Vinkenoog
Hi Duilio,

> I use IBO3 with D3.

I use IBO4 with BCB5. So I'm not sure if what works for me, works for
you too. But this is how I do it in a project of mine:

- Make sure there's a TIB_Connection with the Server and Protocol
fields set.
I also set User en Password before executing the script; not sure
if this is necessary as they also appear in the script itself.

- Have the IB_Connection field of the TIB_Script point the the
abovementioned TIB_Connection. The IB_Transaction field in my case
is <default>

- My script SQL starts like this:
set sql dialect 3;
create database '<<PATH>>'
user '<<USER>>'
password '<<PASS>>'
page_size 8192
default character set ISO8859_1
;
...
...

You don't explicitly connect the TIB_Connection. It is Connected as
soon as the "create database" clause is executed. I know this because
I once ran into trouble with an AfterConnect handler that was called
before the rest of the script had been carried out.


Hope this helps,

Paul Vinkenoog