Hello Nico,

If you want the case preserved, you have to use double quotes, always.


With regards,

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

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

We want to create table- and fieldnames (Firebird 3) in camelcase. If we
want to write a select statement we have to use quotes around a tablename.
This is not userfriendly. Is there a way that we don't have to use the
quotes in SQL-statements ?
We don't want to create our table- and fieldnames in lowercase or uppercase.

Nico Speleers
Analyst





Carfac bvba

Driving on experience


Rijksweg 53
9680 Maarkedal
Tel. +32 55 23 00 00
Fax +32 55 31 00 95
nico.speleers@...
www.carfac.be<http://www.carfac.be/>
[cid:image001.jpg@01D11613.C23F19C0]<http://www.facebook.com/groups/120709181286476/>[cid:image002.jpg@01D11613.C23F19C0]<http://www.linkedin.com/company/hdc-software-nv>
[cid:image003.jpg@01D11613.C23F19C0] <https://twitter.com/carfacbvba>

[Beschrijving: Beschrijving: Beschrijving: CarfacAS
(klein)]<http://www.carfac.be/>


)


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



------------------------------------
Posted by: Nico Speleers - Carfac BVBA <nico.speleers@...>
------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links