Hi everyone, My software ran some DDL statements during a upgrade, and the creation of one FK failed:
26.01.2012 10:18:53.703 | 3360 | INFO | TDBConnectionFirebird[0].ExecSQL: ALTER TABLE EXCESSOS_VELOCIDADE ADD CONSTRAINT FK_EXCESSOS_VEL_POSICAO_FINAL FOREIGN KEY (POSICAO_ID_FINAL) REFERENCES POSICOES (COMUNICACAO_ID) 26.01.2012 10:19:17.233 | 3360 | DBERROR | TDBConnectionFirebird[0].EndTransaction: violation of FOREIGN KEY constraint "***unknown***" on table "EXCESSOS_VELOCIDADE" positive numeric value required I couldn't find any relevant info around this error. Trying to run this same statement on IBExpert i got a different error message: /******************************************************************************* The next statement causes the following error: violation of FOREIGN KEY constraint "". violation of FOREIGN KEY constraint "***unknown***" on table "EXCESSOS_VELOCIDADE". Foreign key reference target does not exist. *******************************************************************************/ ALTER TABLE EXCESSOS_VELOCIDADE ADD CONSTRAINT FK_EXCESSOS_VEL_POSICAO_FINAL FOREIGN KEY (POSICAO_ID_FINAL) REFERENCES POSICOES (COMUNICACAO_ID) ; Which is very odd, because the referece target key does exist and is active. I'm running firebird 2.1.4 on windows. Already done bkp/restore, but the error persist. Tks in advance. [Non-text portions of this message have been removed]
