>On Fri, 8 Jun 2012 11:53:01 +0200, "Martijn Tonies" <m.tonies@...>
>wrote:
>> Hi all,
>>
>> I'm trying to create a Foreign Key Constraint and I'm getting the
>> following
>> error:
>>
>> violation of FOREIGN KEY constraint "FK_LOG_ITEM_LOG" on table
>"LOG_ITEM"
>> Foreign key reference target does not exist
>>
>>
>> However, both tables LOG (master) and LOG_ITEM (detail) are empty!
>>
>>
>> Statement:
>> ALTER TABLE LOG_ITEM ADD CONSTRAINT FK_LOG_ITEM_LOG
>> FOREIGN KEY (LOGID) REFERENCES "LOG"
>> (LOGID)
>> ON DELETE CASCADE
>> ON UPDATE NO ACTION
>>
>>
>> Firebird version:
>> WI-V6.3.0.26074 Firebird 2.5
>>
>>
>> Any clue?

At 09:59 PM 8/06/2012, Mark Rotteveel wrote:

>Doesn't this error indicate that the table or column you are referencing
>doesn't exist? Did you commit the LOG table, is the table actually called
>"LOG", and not "Log", does the column LOGID exist?

Or could be there's no PK or unique constraint on "LOG".LOGID.

./hb