Subject Re: Re: [firebird-support] info
Author liviuslivius
Post date 2017-01-05T14:45:47Z
Hi,
 
when you migrate something and this is reserved word you name it with quotes, and also if it contain space
but i prefer in that migration to change the name instead using double quotes.
But another place where it is vital to have double quotes supported is
select field as "some name for field"
 
regards,
Karol Bieniaszewski
 
W dniu 2017-01-05 12:43:40 użytkownik 'Arno Brinkman' fbsupport@... [firebird-support] <firebird-support@yahoogroups.com> napisał:
 

This "Problem" is listed in the tracker:

http://tracker.firebirdsql.org/browse/CORE-1645

I don't understand who ever though of supporting case-behaviour, why the
hell should i want a table named "ATable" and "atable" and both different
tables.
Anyway this is something what is inherited from the past, let's hope the
firebird developers get some time in the future to solve this.

Kind Regards,
Arno Brinkman
ABVisie

-----Oorspronkelijk bericht-----
From: Nico Speleers - Carfac BVBA nico.speleers@...
[firebird-support]
Sent: Thursday, January 5, 2017 10:36 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] info

Based on table- and columnnames in camelcase our programmers can automatic
create their objects and classes. Therefore we need to create our table- and
columnnames in camelcase. Another reason is readability. We found camelcase
more readable then UPPERCASE.

Have you got a solution for my problem ?

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: donderdag 5 januari 2017 10:23
Aan: firebird-support@yahoogroups.com
Onderwerp: Re: [firebird-support] info

05.01.2017 8:51, Nico Speleers - Carfac BVBA nico.speleers@...
[firebird-support]
wrote:
> If I execute Create table MyTable(aField integer) then the tablename is
> saved as MYTABLE.

Why do you care how it is saved? Just don't look into system tables when
writing your
queries.

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

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