Subject | Re: [firebird-support] compound FK fails |
---|---|
Author | Nick Upson |
Post date | 2008-03-04T10:15:06Z |
The exception occurs when I attempt to define the fk
ALTER TABLE TBLCGCHECKGRID ADD CONSTRAINT FK_TBLCGCHECKGRID_1 FOREIGN
KEY (GROUPID,ASSETID) REFERENCES TBLCUSTOMASSETEDIT(GROUPID,ASSETID)
ON DELETE CASCADE;
violation of FOREIGN KEY constraint '""'. violation of FOREIGN KEY
constraint "PK_TBLCUSTOMASSETEDIT" on table "TBLCUSTOMASSETEDIT".
Foreign key reference target does not exist.
I've tried dbworkbench and dev studio and both come back the same
(This is version 1.5.4)
ALTER TABLE TBLCGCHECKGRID ADD CONSTRAINT FK_TBLCGCHECKGRID_1 FOREIGN
KEY (GROUPID,ASSETID) REFERENCES TBLCUSTOMASSETEDIT(GROUPID,ASSETID)
ON DELETE CASCADE;
violation of FOREIGN KEY constraint '""'. violation of FOREIGN KEY
constraint "PK_TBLCUSTOMASSETEDIT" on table "TBLCUSTOMASSETEDIT".
Foreign key reference target does not exist.
I've tried dbworkbench and dev studio and both come back the same
(This is version 1.5.4)
On 04/03/2008, Helen Borrie <helebor@...> wrote:
> At 08:34 PM 4/03/2008, you wrote:
> >I do commit, I even disconnected and reconnected
>
> Hmm, OK, let's take a step back...
>
> What exactly are you attempting to do at the point where the exception occurs? And what are you using to do it with?
>
> ./heLen
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>