Hello,

this might be the solution since schicht is still empty.

I'll try. Thanks so far. :-)

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.
>