Hi Erik,

> I am using the excellent free Interbase Datapump program from
> www.clevercomponents.com to try to migrate a BDE database to a Firebird
> database.
>
> This tool first generates a SQL script to create all necessary tables,
> indexes etc ...
>
> Everything seems to work, except when it as last action of the script

tries

> to execute the following line:
>
> /* Found Referential Integrity Constraint riArtCode For Table Efas.db */
> ALTER TABLE "EFAS" ADD CONSTRAINT "RIARTCODE"
> FOREIGN KEY ("ARTCODE1", "ARTCODE2")
> REFERENCES "EFA" ("ARTCODE1", "ARTCODE2") ON UPDATE CASCADE;
>
> I did manage to execute and commit all previous sql statements.
>
> This sql statement however seems to be executed correctly, but when I try
> to commit the action, I get a
> 'unsuccessful metadata update
> object EFA in use'
>
> error.
>
> Both the tables EFAS and EFA do exist, the RIARTCODE constraint does not,
> and all fields do exist as well.
>
> Mind you, I am a Firebird primer.

You will also get this error if there's more than 1 connection to the
database.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com