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:
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
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!
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
That is, more or less.
I restarted Firebird, problem is gone.
Even though I already did a sweep and everything, it sounds like there
was some kind of left over transaction or something?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for