Fr. Robert Bower wrote:

>Please excuse the newbie question
>I just tried a couple of different admin tools for firebird and ran
>into some problems and I was wondrering if it is the tools or me.
>In two different tools I tried to create triggers. I wrote the code
>matching the case of the table name and field names but the code
>would not work unless I created the table with the table name and
>field name are all caps.
>
>I am new to firebird so excuse the dumb question. I assumed that
>Firebird is case sensitive that is why it didn't work before but are
>you required in Firebird to name objects in all caps or are the
>tools just assuming that objects will be in all caps?
>
>Thanks
>
>Fr. Robert
>
>

Man,

You don't imagine how ALL CAPS, small caps and Mixed Caps was discussed
last days. :-)

If you put the table name (or other identifier) enclosed on quotes, you
SHOULD use it everywhere with the quotes and with the same case, if you
don't use quotes the identififer will be case insensitive.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18/03/2005