Olá,
boa noite!
Estou com esse erro no meu projeto " VIOLATION OF FOREIGN KEY constraint “FK_CUPOM_1” on table “CUPOM”…
Alguém poderia me ajudar?
O código esta assim da tabela!
Como eu poderia resolver esse erro?
/******************************************************************************/
/*** Generated by IBExpert 17/04/2019 22:53:36 ***/
/******************************************************************************/
/******************************************************************************/
/*** Following SET SQL DIALECT is just for the Database Comparer ***/
/******************************************************************************/
SET SQL DIALECT 3;
/******************************************************************************/
/*** Tables ***/
/******************************************************************************/
CREATE TABLE CUPOM (
CODIGO COD_EXTENDIDO NOT NULL /* COD_EXTENDIDO = VARCHAR(50) NOT NULL /,
NUMERO NUMERO_EM_STRING NOT NULL / NUMERO_EM_STRING = VARCHAR(12) /,
CCF NUMERO_EM_STRING NOT NULL / NUMERO_EM_STRING = VARCHAR(12) /,
ECF SERIAL_ECF NOT NULL / SERIAL_ECF = VARCHAR(30) /,
DATA DATA NOT NULL / DATA = DATE /,
HORA HORA NOT NULL / HORA = TIME /,
QTDE_ITEM QTDE_INTEIRO NOT NULL / QTDE_INTEIRO = INTEGER /,
VALOR_PRODUTO VALOR_2_DECIMAIS NOT NULL / VALOR_2_DECIMAIS = NUMERIC(15,2) /,
VALOR_DESCONTO VALOR_2_DECIMAIS NOT NULL / VALOR_2_DECIMAIS = NUMERIC(15,2) /,
VALOR_ACRESCIMO VALOR_2_DECIMAIS NOT NULL / VALOR_2_DECIMAIS = NUMERIC(15,2) /,
VALOR_TOTAL VALOR_2_DECIMAIS NOT NULL / VALOR_2_DECIMAIS = NUMERIC(15,2) /,
VALOR_PAGO VALOR_2_DECIMAIS NOT NULL / VALOR_2_DECIMAIS = NUMERIC(15,2) /,
VALOR_TROCO VALOR_2_DECIMAIS NOT NULL / VALOR_2_DECIMAIS = NUMERIC(15,2) /,
COD_CLIENTE INTEGER,
CANCELADO INTEGER NOT NULL,
CPF_CONSUMIDOR CPF_CNPJ / CPF_CNPJ = VARCHAR(18) */,
NOME_CONSUMIDOR VARCHAR(40),
COD_VENDEDOR INTEGER,
EX INTEGER DEFAULT 0 NOT NULL,
COD_CAIXA INTEGER DEFAULT 0 NOT NULL,
ECF_CAIXA VARCHAR(3)
);
/******************************************************************************/
/*** Primary Keys ***/
/******************************************************************************/
ALTER TABLE CUPOM ADD CONSTRAINT PK_CUPOM PRIMARY KEY (CODIGO);
/******************************************************************************/
/*** Foreign Keys ***/
/******************************************************************************/
ALTER TABLE CUPOM ADD CONSTRAINT FK_CUPOM_1 FOREIGN KEY (COD_CLIENTE) REFERENCES CLIENTE (CODIGO) ON UPDATE CASCADE;
/******************************************************************************/
/*** Privileges ***/
/******************************************************************************/