hello Martijn,

I've tried it in the constraint editor and in a script editor with
the same result.
At the moment I try to create the Foreign Key there is only one
editor open.

regards,

Andy

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi Andy,
>
> > When I create a foreign key for a table I get the message that

the

> > object is in use. I have the message even if I reconnect.
> >
> > When I backup and restore or just rename the database then I can
> > create the foreign key.
> >
> > I'm working with Fb1.5 rc6. I use the Database Workbench for

DBadmin.

> >
> > Anyone experienced the same problem and/or can it be solved?
>
> Do you create it from the Constraint Editor or the SQL/Script

Editor?

>
> Do you have one or more SQL/Script Editors opened when trying to
> create the constraint from the Constraint Editor?
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird & MS

SQL Server.

> Upscene Productions
> http://www.upscene.com