Subject Re: [IBO] I need your help
Author Lucas Franzen
"H├ęctor Mansilla A." schrieb:
>
> Hi there !
>
> I need your help with a problem...
>
> how can I do with IBO for when I install in a new computer with SQL my
> program create my database.
>
> ooops!
>
> sorry but my english is too bad...
>
> Have a nice day !

You can use the IB_Script component and place all your ddl-statements in
there.

You can either fill it at design time or load it from file(s) at
runtime.

I usually have one script for creating the database, which might look
like:

CREATE DATABASE
C:\DB\MYDB.GDB <you might substitute the name and path>
PAGE_SIZE 4096
USER 'SYSDBA' PASSWORD 'masterkey' <also sustitutable>
DEFAULT CHARACTER SET WIN1252


and several other scripts for the domains, tables, procedures, insert
statements, and so on.

Another tip:
After creating the database it's usually a good idea to disconnect from
the IB_Connection and reconnect (especially when you're using a certain
character set).


HTH
Luc.