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?
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? Mark
