Subject Re: Best way to run metadata update scripts
Author Adam
--- In, "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
> 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.