Hi Claudio and everybody

I got this error message 10 days ago.
And there is an interesting problem.
I was trying to create a foreign key between two tables.
There wasn't any wrong sql statement.
But I got the same message.

After that
I backup the database.
And I restore it.
I created my foreing key.
Everything is ok.
There isn't any problem now.


Ibrahim Bulut
Software Developer
Republic of Turkey

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Saturday, March 23, 2002 11:58 AM
Subject: Re: [ib-support] Re: Unsuccessful metatdata update: Index is in use


> ""dietertremel"" <tremel@...> wrote in message
> news:a7c34b+e884@......
> > --- In ib-support@y..., Daniel Rail <daniel@a...> wrote:
> > > You're not the only one with that problem. I have the same one.
> > And, I
> > > can't find the problem either. Out of curiosity, did this work
> > properly
> > > before FB 1.0? I've only tried it in FB 1.0.
> >
> > I tested on the last machine on which I have IB6 (WI-V6.0.0.627).
> > There is no problem with the same script.
>
> You should have a very special version of IB6, then, because I tried a
> script in exactly the same version than you (6.0.0.627) and got exactly
the
> same error than with FB. The bug happens only if you have CASCADE
> declarations. Borland's flawed implementation of cascade RI has three
> problems:
> - this one;
> - relies on indices like any IB's RI (makes indices mandatory in FKs);
> - database corruption.
>
> The strange INDEX IN USE msg in this specific case has been there since
v5,
> it wasn't introduced by IB6 nor Firebird.
>
> C.
> --
> Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
> Independent developer
> Owner of the Interbase® WebRing
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>