Subject Re: What is My Foreign Key Mistake?
Author inoffensive_2006
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 08:51 PM 16/12/2007, you wrote:
> >Hi Folks:
> >
<Snip>
> >
> > I'm getting this error message:
> >
> > "violation of FOREIGN KEY constraint "INTEG_31" on table "INC"
> > Foreign key reference target does not exist"
> >
> > There is also a complaint about a deadlock, and Firebird seems
> >to wait for about 10 seconds to report the problem. So, I'm not
> >sure what's going on.
<Snip>
> >
> > What am I doing wrong?
>
> It looks as though your two dialogs are in different transactions,
with the child record in a concurrency transaction. The child
record's transaction doesn't know of the existence of the key value it
is meant to associate with.
>
> ./heLen

Thanks Helen:

That was the problem.

Larry