Subject FK creation problem
Author Christian G├╝tter
Hi,

why does this statement fail:

alter table T_BENUTZER
add constraint FK_T_BENUTZER
foreign key (AKTUELLE_PA)
references T_PROVISIONSABRECHNUNGEN(ID)


violation of FOREIGN KEY constraint "".
violation of FOREIGN KEY constraint "PK_T_PROVISIONSABRECHNUNGEN" on table "T_PROVISIONSABRECHNUNGEN".

ID an Aktuelle_PA are both NUMERIC(18,0).

This is the DDL of the constraint that is mentioned in the above text:

ALTER TABLE T_PROVISIONSABRECHNUNGEN ADD CONSTRAINT PK_T_PROVISIONSABRECHNUNGEN PRIMARY KEY (ID);

I am using Firebird 1.03.

TIA,


Christian