I want to create a tablename in camelcase without using quotes.

If I execute Create table MyTable(aField integer) then the tablename is saved as MYTABLE. And yes then you can use camelcase without quotes.

Can you find a solution ?

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
 



-----Oorspronkelijk bericht-----
Van: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Verzonden: woensdag 4 januari 2017 15:48
Aan: firebird-support@yahoogroups.com
Onderwerp: Re: [firebird-support] info

04.01.2017 15:41, Nico Speleers - Carfac BVBA nico.speleers@... [firebird-support]
wrote:

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

Just don't use double quotes:

Create table MyTable(aField integer);
Select aField from MyTable;

No problem if you write queries by hand.
On other hand, if you use a visual query builder, you'll have no problem with double quotes.

--
WBR, SD.


------------------------------------

------------------------------------

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

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