> Is this behavious as designed??

Yes.

> 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;

The view is created without double quotes, meaning it's not case sensitive
and can be used either without double quotes or uppercased with double
quotes.

create view b

means valid is:
select * from "B"/b

create view "b"

means valid is:
select * from "b"

create view "B"

means valid is:
select * from "B"/b

> 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
> -At line 1, column 20

Correct, you shoudl use "B" or simply b

> SQL>
> SQL> create trigger "d" for b
> CON> before insert as
> CON> begin
> CON> end;
> SQL>
> SQL> create trigger "e" for "B"
> CON> before insert as
> CON> begin
> CON> end;
> SQL> show version;
> ISQL Version: WI-V2.1.3.18185 Firebird 2.1
> Server version:
> Firebird/x86/Windows NT (access method), version "WI-V2.1.3.18185 Firebird
> 2.1"
> Firebird/x86/Windows NT (remote server), version "WI-V2.1.3.18185 Firebird
> 2.1/X
> Net (-)/P11"
> Firebird/x86/Windows NT (remote interface), version "WI-V2.1.3.18185
> Firebird 2.
> 1/XNet (-)/P11"
> on disk structure version 11.1

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com