Hello Tanno,

> With FB 1.52 RC3 I tried to place a Foreign Key
>
> ALTER TABLE APK ADD CONSTRAINT F_APK_GROUPID
> FOREIGN KEY (GROUPID) REFERENCES APKGROUP
> (APKGROUPID)
>
> But at commit it gives
>
> ISC ERROR CODE:335544351
> ISC ERROR MESSAGE:
> unsuccessful metadata update
> object APKGROUP is in use
>
> This happens even after shutdown, gbak backup and restore, reboot
>
> Does anyone know a solution ?

If you do this with Database Workbench from the SQL/Script Editor,
make sure that in the Preferences, DB Specific, Firebird the flag
"Use a connection per SQL/Script Editor" is OFF.

You can only have a single connection to a database when creating
FKs.

Or simply use the Constraint Editor and avoid this problem altogether.

With regards,

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