Hi,

At March 22, 2005, 03:28, Martijn Tonies wrote:

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

> Unless you use all-caps :-) ... Then it's case insensitive again.

> So, in general, if you want to avoid case problems, don't use quotes. But
> Firebird isn't case preserving either.

> If you want to use case, reserved words and make it case preserving,
> use double quotes.

The problem that he's having is that some tools will automatically put
the double quotes around identifiers(table, fields, domains to name a
few), if the identifier was not entered in all caps. I know EMS
Quickdesk does that and I don't know if the recent versions still do
it(I'm still using version 2.9). The option that I have with Quickdesk
is one check mark on the database registration form to automatically
use all-caps for identifiers, and by default it's unchecked.

The tool shouldn't do this unless an option exists to automatically
put identifiers in double-quotes, or that the user implicitly placed
the double-quotes. This is were some newbies get confused, I know I
was when I started to use Interbase 6 beta(before Firebird's
existence).

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)