Subject Re: [firebird-support] compound FK fails
Author Nick Upson
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)

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
>
>
>
>