Subject | FullTextSearch Error... |
---|---|
Author | cgar1136 |
Post date | 2005-11-28T21:53:30Z |
When i run the IB_FTS.exe demo and follow the instructions on the
tutorial online about FullTextSearch i get the next error:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, char 32
NOT
STATEMENT:
TIB_DSQL: "IBO_DefaultSession.dmFTS_Scripts.scLoadMeta.<TIB_DSQL>."
and at the SQL tab says:
CREATE TABLE FTS$<<IND_NME>>$WRD (
FTS$<<KEY_COL>> <<KEY_DM>> NOT NULL,
FTS$WRD FTS$<<IND_NME>>$WRD_DM NOT NULL,
FTS$MTP FTS$<<IND_NME>>$WRD_DM NOT NULL,
FTS$SDX FTS$SDX_DM NOT NULL,
FTS$SMX FTS$SDX_DM NOT NULL,
FTS$SYN FTS$<<IND_NME>>$WRD_DM NOT NULL,
FTS$ANT FTS$<<IND_NME>>$WRD_DM NOT NULL )
What i'm doing wrong??? any other thing that must i know before try to
use FTS???
Cheers...
tutorial online about FullTextSearch i get the next error:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, char 32
NOT
STATEMENT:
TIB_DSQL: "IBO_DefaultSession.dmFTS_Scripts.scLoadMeta.<TIB_DSQL>."
and at the SQL tab says:
CREATE TABLE FTS$<<IND_NME>>$WRD (
FTS$<<KEY_COL>> <<KEY_DM>> NOT NULL,
FTS$WRD FTS$<<IND_NME>>$WRD_DM NOT NULL,
FTS$MTP FTS$<<IND_NME>>$WRD_DM NOT NULL,
FTS$SDX FTS$SDX_DM NOT NULL,
FTS$SMX FTS$SDX_DM NOT NULL,
FTS$SYN FTS$<<IND_NME>>$WRD_DM NOT NULL,
FTS$ANT FTS$<<IND_NME>>$WRD_DM NOT NULL )
What i'm doing wrong??? any other thing that must i know before try to
use FTS???
Cheers...