IMPORTANT Is using the underscore, considered upper case, ie needing quotes

To summarize what Doug Easterbrook and Jim have explained:

invoice_id – no need for quotes – GOOD

invoiceid – no need for quotes – GOOD

All other cases will need quotes and are not recommended for the reasons
that Doug explained.

InvoiceID – needs quotes

INVOICE_ID – needs quotes

INVOICEID – needs quotes

The same goes for table names and the names of other database objects, like
indexes, sequences, stored procecedures, etc.

Regards,

Clifford Ilkay

+1 647-778-8696

On Mon, Jan 29, 2018 at 4:00 PM, Das Goravani <das@goravani.com> wrote:

>
> Do you have to double quote a field name that uses an underscore, which is
> a shift key character, upper case, no?
>
> Does that cause the field to need double quotes ?
>
> I’m weeding out all the difficulty early on in my app which is in early
> stages of course. I want to fix the naming conventions NOW.
>
> I removed upper case because it was going into the database and requires
> so many double quotes everywhere.
>
> If the underscore is just another upper case letter then I want to part
> with it as well.
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com
>
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com