At 11:54 PM 21-11-00 -0500, you wrote:

>Hi:
>
> Now I am somewhat confused again.
>
> I just recreated the table:
>
>CREATE TABLE TRGREV
>(
> REVISION DOUBLE PRECISION,
> REVDATE DATE
>);
>
>
>And the meatadata is:
>
>CREATE TABLE "TRGREV"
>(
> "REVISION" DOUBLE PRECISION,
> "REVDATE" DATE
>);
>
>
>So if I created another table:
>
>CREATE TABLE "TRGREV1"
>(
> "REVISION" DOUBLE PRECISION,
> "REVDATE" DATE
>);
>
>
>And the meatadata:
>
>CREATE TABLE "TRGREV1"
>(
> "REVISION" DOUBLE PRECISION,
> "REVDATE" DATE
>);
>
>So it appears that whether I use quotes in the Create or not makes
>no difference in the result. Is that correct?

>CREATE TABLE TRGREV
>(
> REVISION DOUBLE PRECISION,
> REVDATE DATE
>);

will store TRGREV, REVISION AND REVDATE case-insensitively.

These SQL statements will work:

select revision, revdate from trgrev
SELECT REVISION, REVDATE FROM TRGREV
select Revision, Revdate from TrgRev

etc.

As soon as you create the metadata with the double quotes, the object names
become case-sensitive.

So -

CREATE TABLE "TRGREV1"
(
"REVISION" DOUBLE PRECISION,
"REVDATE" DATE
);

select revision, revdate from trgrev <==won't work
SELECT REVISION, REVDATE FROM TRGREV <== will work
select Revision, Revdate from TrgRev <== won't work

Try using the IB_Wisql client to inspect/dump the metadata. It is built
with IB Objects, which properly handles the case-sensitivity issue.

Helen
------------------------------------------------------------------

>Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
>Shortcut URL to this page:
> http://www.onelist.com/community/IBDI

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
___________________________________________________