> That was it, I'll contact both tool authors seperately, thanks

Hi Nick,

For one thing, I can tell you that the error message comes straight
from Firebird. Why it is a bit weird at your end, I do not know.

Are you sure you have the correct message file?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> On 04/03/2008, Helen Borrie <helebor@...> wrote:
> > At 09:15 PM 4/03/2008, you wrote:
> > >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)
> >
> > Well, I did exactly your DDL in IB_SQL (copy and paste, as DSQL

statements), with commit after the creation of each table, and it all simply
worked (also v.1.5.4). I'm suspicious about the tool(s) you are using:
both seem to be making the same mistake, since the topmost error message as
reported here is scrambled....try it with isql.

> >