Hello Mark, >> 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?
The table is LOG, with column LOGID as the PK. Unknown columns gets error: unsuccessful metadata update could not find UNIQUE or PRIMARY KEY constraint in table LOG with specified columns Unknown table gets error: unsuccessful metadata update Table LOG2 not found The statement was generated by Database Workbench, I added quotes because I thought maybe there was a bug in DBW and it would help, same result though. 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!
