Hi Richard,

> Indeed the Uppercase/Lowercase was the problem, if I now rebuild the
> database. Thus everything need to be in uppercase (views,triggers,etc

etc).

>
> And where do I find doc, about this subject....

There are currently no specialized Firebird docs, only the InterBase beta
ones.

Anyway, either:

- never use those quotes

or

- use quotes, but uppercase all object names

Better yet, get yourself a tool that simply has a setting "Uppercase
identifiers"
like in Database Workbench - this avoids all this crap. Database Workbench
will also warn you if you're trying to create objects with names that would
need
delimited identifiers, like keywords, or names with spaces in it. In short:
it will
help you to create un-delimited identifier objects.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com