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?

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!