As a part of small update on my database. I tried to create a primary key on the table called Transact. This table contains the entity called 'CODE'. I am using gerator ( defined in the database as TRANSACT_CODE_GEN) to supply the value. There is no chance of duplicate values for entity CODE.
There was one primary key on this table and index related to this primary key as under:
PK_TRANSACT_DOCKET_SITEID & UNI_TRANS_CODE_INDEX
Despite of making sure that, there is no duplicate value in CODE,no similar primary key, I keep getting this error message while creating a new primary key.
"Attempt to store duplicate value (visible to active transactions) in unique index "RDB$PRIMARY79"
Statement: alter table transact add CONSTRAINT PK_TRANSACT_CODE PRIMARY KEY (CODE)"
I have tried converting the database in the latest version of Interbase 2007 and 7.5 and this error doesn't come up in the latest version.
Would any one please assist me to either rectify this or tell me, If there is any issue with Interbase 6.5?