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