|Subject||RE: [IBO] TIB_Query Question|
>>It is present in your situation because you did not explicitlyGeoff,
>>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).
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.
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)^