> We want to create table- and fieldnames (Firebird 3) in camelcase.

You can do that now, you can use whatever case you want.


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

By SQL standard Object names are case insensitive, so all objects are 
upper-cased.

There is an exception for objects created as "identifiers" which requires the 
use of double-quotes (another SQL standard) for all references to the Objects.


> We don't want to create our table- and fieldnames in lowercase or
> uppercase.

While the engine would return/display the object names in upper case, that does 
not stop you from using CamelCase in your SELECT statements, Triggers and SPs 
-- This is something that I do religiously, even after 20 years of using IB/FB.


Sean

  • ... Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
    • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • ... Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
        • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
          • ... Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
            • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
            • ... 'Arno Brinkman' fbsupp...@abvisie.nl [firebird-support]
            • ... Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
        • ... 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
    • ... 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
    • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
    • ... Ann Harrison aharri...@ibphoenix.com [firebird-support]
    • ... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
    • ... Nico Speleers nico.spele...@carfac.com [firebird-support]
      • ... Рустам Муса-Ахунов rusta...@ukr.net [firebird-support]
    • ... Nico Speleers nico.spele...@carfac.com [firebird-support]
      • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
      • ... Helen Borrie hele...@iinet.net.au [firebird-support]
        • ... 'Zoran' zoran...@gmail.com [firebird-support]
          • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]

Reply via email to