Subject | Re: What is My Foreign Key Mistake? |
---|---|
Author | inoffensive_2006 |
Post date | 2007-12-17T00:20:06Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
record's transaction doesn't know of the existence of the key value it
is meant to associate with.
That was the problem.
Larry
><Snip>
> 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.
> >with the child record in a concurrency transaction. The child
> > What am I doing wrong?
>
> It looks as though your two dialogs are in different transactions,
record's transaction doesn't know of the existence of the key value it
is meant to associate with.
>Thanks Helen:
> ./heLen
That was the problem.
Larry