At 03:45 AM 9/7/2001 +0000, hinfun@... wrote:

>I have problems creating foreign keys in IB.
>
>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"

Which version of InterBase? Would you send a script that defines
those tables & demonstrates the error?

If the version of InterBase is FB1 Beta 2, I think I know what the
problem is and will be sure that it doesn't happen in the next release.


Regards,

Ann
www.ibphoenix.com
We have answers.