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.

jwc



_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Helen Borrie
Sent: Thursday, January 18, 2007 10:03 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] IB_FTS Issues



At 01:29 PM 19/01/2007, you wrote:

>Please advise if this is the right place to get help with IB_FTS.
>I compiled the app and want to set up my index. I'm assuming that the Table
>Key Column is the primary key, and the search column is the column which is
>the target of the FTS.
>Anyway, the first step, according to the CPS Full Text Search Utility Help
>file, is to enter a name for my index. On typing the first character of the
>index name, I generate an error:
> ISC ERROR CODE:335544569
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -204
> Table unknown
> (table name)
> At line 1, column 10.
> STATEMENT:
> TIB_Cursor: "<TApplication>.frmFTS.crTXT."
>Any ideas appreciated.

Is (table name) the actual text in the message? If not, could you
post the actual error text.

Is your database using double-quoted table identifiers?

Helen





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