--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:

> 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.
>

Thank you! I have used a similar technique with SQLServer/ADO and it
has always worked; that is what was mystifying about the problem.

Tom
______________________________________________________________________