Subject Re: [ib-support] Re: Firebird 1.0 - Error creating multiple tables
Author Helen Borrie
At 02:23 PM 10-08-02 +0000, you wrote:

> > What happens if you add this line:
> >
> > DM.IBTransaction1.Commit;
> >
> > after executing the first query?
> >
> >
>It creates the database and the first table; then errors on the
>second ExecQuery.

Sending DDL statements through the client interface in Delphi is not
recommended. In the case of creating a database and its objects it
is >>particularly not recommended<<.

Instead, use a script component which accesses the same DDL utility
services that isql uses for script processing and allows you to use the
special isql SQL commands for setting the object creation environment,
including SET AUTODDL. Both IB Objects and the IBX Service Components
include script components, which are documented.

As this is not a Delphi list, you will need to take Delphi questions to the
appropriate forum for more information: borland.public.interbasexpress on
news:// for IBX,
or for IB Objects. I think
FIBPlus also now has a script component, but I don't know the address of
its support list.

(mail admin)

All for Open and Open for All
Firebird Open SQL Database · ·