Subject | Re: Field names upper case - true of firebird 2.0 also? |
---|---|
Author | MichaelS |
Post date | 2005-05-09T04:48:47Z |
--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
TBLITEM...at least the db management tools I've looked at all change
to uppercase. Yes it is good if firebird sees tblItem and knows it's
TBLITEM, but I'd rather have the table and field names themselves have
the flex.
> --- In firebird-support@yahoogroups.com, "MichaelS"OK; but I can't *create* a table named tblItem, right? Would be
> <pitterpattern@y...> wrote:
> > I'm quite unused to firebird's apparent use of uppercase letters for
> > field names etc. Is this an acutal requirement, or is it optional?
>
> It is already optional.
>
> Try it in iSQL.
>
>
> CREATE TABLE TABLEA
> (
> FIELD1 INTEGER
> );
>
> COMMIT;
>
> select count(field1)
> from tablea;
>
> should work.
TBLITEM...at least the db management tools I've looked at all change
to uppercase. Yes it is good if firebird sees tblItem and knows it's
TBLITEM, but I'd rather have the table and field names themselves have
the flex.