> >> 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?
>
> I'd say not. The topmost message (the one that is scrambled) is isc code

335544466, gds_code foreign_key, which is present in both the Fb 1.5.x and
Fb 2.0.x message dbs. However the first (lower) one is 335544838,
foreign_key_target_doesnt_exist, which is present only in the Fb 2 and
higher message dbs.

>
> So it seems Nick might have some messed-up arrangements there, doesn't it?

It still isn't an (obvious) explanation why that sequence of statements
should have returned *any* exception, though.

>

Agreed, but without the proper error message, it's hard to tell :-)

My first guess would be having multiple connections. Each SQL/Script Editor
in Database Workbench can optionally open a secondary connection for
threaded querying. This can be turned OFF in the Preferences. If the
SQL/Script Editor opens a secondary connection, the script will fail in Fb <
2.0

> ./heLen
> > > >
> >> > >violation of FOREIGN KEY constraint '""'. violation of FOREIGN KEY
> >> > >constraint "PK_TBLCUSTOMASSETEDIT" on table "TBLCUSTOMASSETEDIT".
> >> > >Foreign key reference target does not exist.

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