Hi,

I tried it out, filled the table SCHICHT with the needed data and used the statement

Alter table DATEN add foreign key (SCHICHT) references SCHICHT (SCHICHTID) on update no action on delete cascade;

Now I receive the error:

Deadlock
violation of FOREIGN KEY

Best Regards
Bernhard

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, July 27, 2001 11:47 AM
Subject: Re: [ib-support] another Error


> >Violation of FOREIGN KEY constraint "INTEG_95" on table "SCHICHT"
> >Statement: Alter table DATEN add foreign key (SCHICHT) references
> >SCHICHT (SCHICHTID) on update no action on delete cascade
>
> >How to find out what fields are indexed or referenced by INTEG_95 ?
>
> Don't know the answer to your question, but try
> SELECT DISTINCT SCHICHT FROM DATEN
> WHERE NOT EXISTS(SELECT 1 FROM SCHICHT WHERE SCHICHT.SCHICHTID =
> DATEN.SCHICHT)
> to find which values of SCHICHT exist in DATEN that is not in your SCHICHT
> table.
>
> Set
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>