--- In firebird-support@yahoogroups.com, "fakuva" <bjorn@...> wrote:

>
> Hello,
>
> I have an application that connects to an firebird database with ADO
> (Delphi) throug ODBC. This application need to add a couple of new
> tables with foreign keys and add some columns to already existing

table.

>
> Currently I'm sending these DDL commands one by one using a ADOCommand
> component, but this creates a lot of problem. For instance I get an
> error indicating that the table is in use when I try to create a
> foreign key etc.
>
> I'm wondering what the best practice is when you want to perform such
> operations and it must be integrated into an application?
>

Ideally, make sure you are the only user and commit after each DDL
operation, and you will not have problems.

Adam