> found out what was happening, the developer had data in the table that
> would not be allowed by the FK, hence the exception. (SFX of smacking
> developer round head when he says "does it matter if there is data in
> the table").

Well, that would explain the error message :-)

However, that would not explain why it worked in "isql".

> Why the error message was scrambled I don't know as there is only one
> firebird.msg file on that machine.

If the above is true, I guess the error becomes less scrambled and makes
more sense as it was telling you what was wrong.

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