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