At 10:25 PM 4/09/2012, Cam wrote: >FB Version 2.5.1.26351 > >I have a table (test) with a unique constraint on a field ID_NUMERIC. >CREATE TABLE TEST >( ID BIGINT NOT NULL, > ID_NUMERIC INTEGER NOT NULL, > CONSTRAINT PK_TEST PRIMARY KEY (ID) >); >CREATE UNIQUE ASC INDEX UI_ID_NUMERIC ON TEST (ID_NUMERIC); > > >Table TESTFK is >CREATE TABLE TESTFK >( > ID BIGINT NOT NULL, > NUMERIC_ID INTEGER NOT NULL, > DESCR VARCHAR( 21) COLLATE NONE, > CONSTRAINT PK_TESTFK PRIMARY KEY (ID) >); > >If I try to add a FK .. >ALTER TABLE TESTFK ADD CONSTRAINT TESTFK_FK > FOREIGN KEY (NUMERIC_ID) REFERENCES TEST(ID_NUMERIC) > ON DELETE CASCADE > ON UPDATE CASCADE; > >I get the following error. >Script Error: >unsuccessful metadata update >could not find UNIQUE or PRIMARY KEY constraint in table TEST with >specified columns
It must be a unique CONSTRAINT. Just defining a unique index is not enough. >I'm sure this used to work? Nope, it never did. ./heLen
