| Subject | Re: [IBO] I need your help |
|---|---|
| Author | Lucas Franzen |
| Post date | 2002-09-02T18:22:26Z |
"Héctor Mansilla A." schrieb:
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.
>You can use the IB_Script component and place all your ddl-statements in
> 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 !
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.