Subject Re: [firebird-support] compound FK fails
Author Helen Borrie
At 10:15 PM 4/03/2008, Martijn wrote:


>> That was it, I'll contact both tool authors seperately, thanks
>
>Hi Nick,
>
>For one thing, I can tell you that the error message comes straight
>from Firebird. Why it is a bit weird at your end, I do not know.
>
>Are you sure you have the correct message file?

I'd say not. The topmost message (the one that is scrambled) is isc code 335544466, gds_code foreign_key, which is present in both the Fb 1.5.x and Fb 2.0.x message dbs. However the first (lower) one is 335544838, foreign_key_target_doesnt_exist, which is present only in the Fb 2 and higher message dbs.

So it seems Nick might have some messed-up arrangements there, doesn't it? It still isn't an (obvious) explanation why that sequence of statements should have returned *any* exception, though.

./heLen
> > >
>> > >violation of FOREIGN KEY constraint '""'. violation of FOREIGN KEY
>> > >constraint "PK_TBLCUSTOMASSETEDIT" on table "TBLCUSTOMASSETEDIT".
>> > >Foreign key reference target does not exist.