Subject Re: [ib-support] Firebird 1.0 - Error creating multiple tables
Author Paul Reeves
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?


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase