----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, November 24, 2004 8:32 AM
Subject: Re: [firebird-support] Object in use bug still present


>
> 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
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>