create table "myTable" (
"fieldID" integer
)

Now this FAILs:
select * from myTable


I think it will be usefull to allow server do not UPPERCASE myTable if it without quotes
at least in my case.

it will great if I will be able to configure server like this
# Upper case object names
#DEFAULTUPPERCASE= TRUE
DEFAULTUPPERCASE= FALSE

so when I run query
select * from myTable
server will not uppercase myTable and will use object names AS IS
for example, myTable in this case

----- Original Message -----
From: Alan McDonald
To: firebird-support@yahoogroups.com
Sent: Tuesday, December 04, 2007 1:02 PM
Subject: RE: [firebird-support] Upper case behaviour


> Hello
> Can I disable server to uppercase object names?
> So when I write
> select fieldID from myTable
> server return 'fieldID' from 'myTable' not 'FIELDID' from 'MYTABLE'
>
>
> Eugenk Konkov

If you create your objects enclosed in single quotes, they will be forever
as you create them.
You have to always refer to them in single quotes.
Alan





[Non-text portions of this message have been removed]