--- In ib-support@y..., Paul Reeves <paul@f...> wrote:

> Tom Hahn wrote:
> >
> > DM.IBDatabase1.Params.Add(MyTimeStrg);
> > DM.IBDatabase1.CreateDatabase;
> >
> > DM.IBSQL1.SQL.Clear;
> > DM.IBSQL1.SQL.Add(ClientTableCreateStrg);
> > DM.IBTransaction1.Active := true;
> > DM.IBSQL1.ExecQuery;
> >
> > DM.IBSQL1.SQL.Clear;
> > DM.IBSQL1.SQL.Add(ProjectTableCreateStrg);
> > DM.IBTransaction1.Active := true;
> > DM.IBSQL1.ExecQuery;
> >
>
>
> 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.

Tom