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

no, generated statement based on selecting the constraint from a drop down
box. ;)

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!