At 11:14 AM 18/06/2010, you wrote:

>Is this behavious as designed??

Yes; and per the standard.

>C:\DOCUME~1\-\LOCALS~1\Temp>isql -user sysdba -pass masterkey
>Use CONNECT or CREATE DATABASE to specify a database
>SQL> create database "db.fdb";
>SQL> create table a(id integer);
>SQL> create view b(id) as select id from a;
>SQL>
>SQL> create trigger "c" for "b"
>CON> before insert as
>CON> begin
>CON> end;
>Statement failed, SQLCODE = -204
>Dynamic SQL Error
>-SQL error code = -204
>-Table unknown
>-b

Double-quoting an object name makes it case-sensitive and, thereafter, you have to keep double-quoting it forever and using it case-correct. Without double-quotes, the engine upper-cases the object name at creation time. Subsequently, you can refer to it (without the quotes, only) in either upper case, lower case or anything in between.

So the table's name is B, not "b".

./heLen