Hi,

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.

Thanks for any advice you might give me,

Erik De Laet