At 08:48 PM 21-11-00 -0500, you wrote:

>HI:
>
>In IBConsole I executed:
>
>CREATE TABLE "TRGRev"
>(
> "TRGRev" DOUBLE PRECISION,
> "TRGIssueDate" DATE
>);
>
>
>Database metaData shows:
>
>
>/* Table: TRGRev, Owner: SYSDBA */
>
>CREATE TABLE "TRGRev"
>(
> "TRGRev" DOUBLE PRECISION,
> "TRGIssueDate" DATE
>);
>
>Table is listed in Tables.
>
>When I try to open table to addd records error -204 Table Unknown.
>
>Any suggestions appreciated. (I can't drop it either.)

The double-quoted format you used to create the table makes the table and
column names case-sensitive. So, if your SQL statement for inserting is

INSERT INTO TRGREV(TRGREV,TRGISSUEDATE)
VALUES(BLAH1, BLAH2)

then the engine can't find the table.

INSERT INTO "TRGRev"("TRGRev", "TRGIssueDate")
VALUES(BLAH1, BLAH2)

will do it for you.

Advice: don't define objects using the double-quoted syntax EXCEPT FOR
objects that are named with InterBase reserved words, or which contain
spaces in their names.

Cheers,
Helen

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