I have problems creating foreign keys in IB.
I have try this on the Interbase Open Edition and it doesn't work.
This has been post to borland interbase newsgroup as well and
apparently the certified version behaves the same according to
respondents. I tried this on Firebird and it looks the same.
I really doubt this is normal and hopefully there is a patch for this.


The problems as belows :

I execute the foreign key from Interactive SQL : (this is just 1 of
them)

alter table AMX_TP_DATE_CONTROL
add constraint fk_amx_2065 foreign key (COMPANY_CODE, BRANCH_CODE)
references AMX_BRANCH_TABLE (COMPANY_CODE, CODE)
on delete cascade;

It returns the following when executing the script :
Attempt to store duplicate value (visible to active transactions) in
unique index "RDB$INDEX_16"


I have ensure the following :
1. There is no such foreign key created in the Database.
2. Clean Installation and generated around 8 tables which includes
the 2
above.

Thanks