Subject RE: [IBO] TIB_Query Question
Author Marv Cook
>>It is present in your situation because you did not explicitly
>>provide keylinks - to tell IBO how to uniquely identify each record
>>and either KeyLinksAutoDefine is disabled or the table does not have
>>a primary key (which is generally not a good idea).

Geoff,

When I defined a KeyLinks field, the DB_KEY field went away. However, I did
have a key field defined (see below) and KeyLinksAutoDefine was true.

Marv


From IB_SQL ...

CREATE TABLE OTTYPE (
OTTID RID /* INTEGER */ NOT NULL,
NAME /* RDB$29 */ VARCHAR(40) CHARACTER SET NONE,
WATER BOOLEAN /* CHAR(1) CHARACTER SET NONE */ DEFAULT "F",
DEFAULTSUMMARY RID /* INTEGER */
)^
ALTER TABLE OTTYPE ADD
PRIMARY KEY (OTTID)^