Greetings All,
Firebird v2.5.4 Trying to create a simple table and receive this error: unsuccessful metadata update cannot create index PK_CUR_CASE_INV_NON_JUD_CNT while executing: ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT FK_CUR_CASE_INV_RPT3 FOREIGN KEY (REPORT_ID) REFERENCES CUR_CASE_INV_RPT (REPORT_ID) ON DELETE CASCADE ON UPDATE NO ACTION Here is the DDL: CREATE TABLE CUR_CASE_INV_NON_JUD_CNTY ( REPORT_ID INTEGER NOT NULL, FILING_COUNTY VARCHAR( 54) NOT NULL COLLATE NONE, NON_JUD_COUNT INTEGER NOT NULL, NON_JUD_AMT NUMERIC( 15, 2) NOT NULL, CONSTRAINT PK_CUR_CASE_INV_NON_JUD_CNT PRIMARY KEY (REPORT_ID, FILING_COUNTY) ); COMMENT ON TABLE CUR_CASE_INV_NON_JUD_CNTY IS '07.19.16 Stores the filing counties and non judgment data for use with the current case inventory stats report.'; ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT FK_CUR_CASE_INV_RPT3 FOREIGN KEY (REPORT_ID) REFERENCES CUR_CASE_INV_RPT (REPORT_ID) ON DELETE CASCADE ON UPDATE NO ACTION ; Any ideas? Mike
