I think I know the answer. That table was created as TestingTable with the
caps option turned off. All other tables were created with capital letter
names. I can drop that table, and just did so, clearing the problem. Thanks
Helen.



_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Helen Borrie
Sent: Friday, January 19, 2007 12:09 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IB_FTS Issues



At 02:10 PM 19/01/2007, Jack Cane wrote:

>Here is the complete error message:
>ISC ERROR CODE:335544569
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -204
>Table unknown
>TESTINGTABLE
>At line 1, column 10.
>
>STATEMENT:
>
>TIB_Cursor: "<TApplication>.frmFTS.crTXT."
>
>I am not knowingly using double quoted table names. There are no quotes
>around table names when looking at them in Database Workbench.
>TestingTable is one of 7 tables in my database. FTS has added an 8th
>table, FTS$_IND.
>
>Hope that answers your question.

Yes it does. In DBW, could you please run this query in a DSQL window:

select rdb$relation_name from rdb$relations
where rdb$relation_name not starting with 'RDB$'
order by 1

and report whether you see TESTINGTABLE or TestingTable in the output.

Helen





[Non-text portions of this message have been removed]