Subject | Re: FK violation in FB 1.5 |
---|---|
Author | tomkrej |
Post date | 2009-01-19T15:36:05Z |
Hi,
You have to correct values in database.
You can select all error rows in table TRUCK
e.g.
select * from TRUCK where (select CARRIER_ID from CARRIER where
CARRIER.CARRIER_ID = TRUCK.CARRIER_ID) is null;
correct them - set NULL, or some default value
then do backup/restore cycle
Tom
You have to correct values in database.
You can select all error rows in table TRUCK
e.g.
select * from TRUCK where (select CARRIER_ID from CARRIER where
CARRIER.CARRIER_ID = TRUCK.CARRIER_ID) is null;
correct them - set NULL, or some default value
then do backup/restore cycle
Tom