Re: [Firebird-test] Mixed case object names

[Aage J. <aag...@on...>]

On Sat, 25 Oct 2003 07:06:12 +0000 (UTC), André Parnelöv wrote:

> I'm really sure if this is a bug or design.
>
> I have problem with objects name in mixed case. When I run a query for my
> object I just get an error telling me that either the table or column
> doesn't exist.
>
> I run Firebird 1.5 rc6, with both IBExpert and Firebird.net-provider. The
> errors I get is similar in both interfaces.
>
> Example.
> The table tbl_Test has the columns mKey and mValue. I'm trying to insert
> values into the table with:
>
> INSERT INTO "tbl_Test" (mKey,  mValue) VALUES ('andre',12);
>
> And the error I get is;
> Dynamic SQL Error
> SQL error code = -206
> Column Unkown.
> MKEY
> At line 1, column 25
>
> But if I create a new table with only uppercase object names there is no
> problem running a query in mixed case.
>
> I really like to have mixed case object names.


Well, I you really like to punish yourself ...
Try to use "mKey" and "mValue".

I find it most convenient to use UPPERCASE names (with no " quotes) when 
defining objects.  I can then use AnyCase in my Delphi programs.


-- 
Aage J.