At 01:35 AM 23-02-01 +0100, you wrote:

>Hi Helen,
>
>At 10:55 23.02.2001 +1100, you wrote:
> >What happens if you use this syntax:
> >
> >ALTER TABLE BEHARTEN ADD CONSTRAINT FK_BEH_PLACES FOREIGN KEY
> >(BEH_ID_PLACE) REFERENCES PLACES
> >(PL_ID_PLACE);
> >
> >Helen
>
>this didn't work, too.
>I just found the problem in older mails. I had indexes defined on some of the
>referenced PK fields. According to a mail of Ann Harrison there is a bug in
>Interbase that prevents one from creating FKs if there are indexes on the
>referenced PK fields.
>
>I suspect these indexes were left from the migration from paradox a few years
>ago when I used a tool to create a sql script of my paradox tables and then
>built
>the IB database with it.
>
>I dropped these indexes and my script with about 50 FKs executed fine !
>
>Thanks anyway Helen !

Markus,
Thank YOU. You have just inspired me to do something I had overlooked, in a tutorial task I'm currently busy with.

Kia ora!

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________