At 09:38 PM 21-11-00 -0500, you wrote:

>Hi:
>
> Something is rotten:
>
>Table is listed in Tables.
>
>To open it or drop it I had to "TRGRev". Didn't like that so I
>dropped it.
>
>So I recreated:
>
>CREATE TABLE "TRGREV"
>(
> "TRGRev" DOUBLE PRECISION,
> "TRGIssueDate" DATE
>);
>
>Fine.
>
>Opened table in IBConsole and tried to add records.
>
>Fields were shown as TRGRev and TRGIssueDate.
>
>When I tried to add data, got error that fields didn't exist. It
>didn't like the TRGRev without quotes but in the Table->Data in
>IBConsole it showed exactly that, TRGRev and not "TRGRev".
>
>This is absurd. Changed them to all caps and all is well

It's not absurd. It is intended to improve compatibility when converting
databases from another engine. Don't use double quotes at all except on
field names like "Day", "Value", etc. (which are IB reserved symbols) or
"Revision Date" which contains a space.

To remove the problems, I would have recreated the table like this:

CREATE TABLE TRGREV
(
TRGRev DOUBLE PRECISION,
TRGIssueDate DATE
);

You are making work for yourself by unnecessarily introducing the need to
handle case-sensitive table and column names.

Helen

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