Hi

Maybe this isn't the place to ask, but anyway.

When using a Firebird DB I can do this:

alter table FARVE_OMSETNING add constraint FarveOmsetFARVEKEY foreign
key
(NAVN) references FARVER(NAVN);
Commit;

without anything.

But doing the same on a IB 6.0.1.6 gives me this error:

unsuccessful metadata update
STORE RDB$REF_CONSTRAINTS failed
action cancelled by trigger (1) to preserve data integrity
Name of Referential Constraint not defined in constraints table


Michael