integrity constraint violated - parent key not fou
Publicado por JJ (5 intervenciones) el 20/02/2002 21:49:48
integrity constraint (COSE.SYS_C0020334) violated - parent key not found
a que se debe este error, no tengo llaves duplicada.... de hehco, la tabla está vacia??
como lo resuelvo, este es la sentencia:
insert into tbcose values ('02-3','a','3','3jujo','a',null,null,'1','cliente','a',null,null,null,null,null,null,null,null,null,null,'1',null,'1','1',null,'1',null,null,null,null)
y la tabla es esta:
app varchar(10) unique references tbini,
appenglog varchar(10),
track number unique,
userid varchar(10) primary key,
rev varchar(3),
datein date,
dateout date,
wkd number,
customer varchar(80),
subject varchar(50),
gts varchar(50),
location varchar(50),
model varchar(50),
ml varchar(50),
units varchar(50),
fuel varchar(20),
turbine varchar(10),
requirement CLOB,
summary CLOB,
system varchar(15),
cost number,
swl varchar(15),
mhe number,
mhd number,
lab varchar(15),
cycle number,
risk varchar(3),
explanation CLOB,
comments CLOB,
status varchar(2)
Gracias
a que se debe este error, no tengo llaves duplicada.... de hehco, la tabla está vacia??
como lo resuelvo, este es la sentencia:
insert into tbcose values ('02-3','a','3','3jujo','a',null,null,'1','cliente','a',null,null,null,null,null,null,null,null,null,null,'1',null,'1','1',null,'1',null,null,null,null)
y la tabla es esta:
app varchar(10) unique references tbini,
appenglog varchar(10),
track number unique,
userid varchar(10) primary key,
rev varchar(3),
datein date,
dateout date,
wkd number,
customer varchar(80),
subject varchar(50),
gts varchar(50),
location varchar(50),
model varchar(50),
ml varchar(50),
units varchar(50),
fuel varchar(20),
turbine varchar(10),
requirement CLOB,
summary CLOB,
system varchar(15),
cost number,
swl varchar(15),
mhe number,
mhd number,
lab varchar(15),
cycle number,
risk varchar(3),
explanation CLOB,
comments CLOB,
status varchar(2)
Gracias
Valora esta pregunta


0