>On Fri, 8 Jun 2012 11:53:01 +0200, "Martijn Tonies" <m.ton...@upscene.com> >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