rmarles
19th September 2006, 17:06
Hello
trying to insert a null value into say tfgld215.dim2 via an odbc connection to the oracle database;
insert into baan.ttfgld215100
(t$idno, t$dnum, t$lino, t$tcom, t$leac, t$dim1, t$dim2, t$dim3, t$dim4, t$dim5, t$cvat, t$tvat, t$amnt, t$dbcr, t$vamt, t$qty1, t$qty2, t$refr, t$fyer, t$fprd, t$txta, t$imst, t$rprd, t$ryer, t$refcntd, t$refcntu)
values
('robm1234','0','0','100','12345','678','','','','','','','100.00','C','0','0','0','This is a test!','2007','09','0','1','09','2007','0','0')
This yields the following message:
ERROR at line 4:
ORA-01400: cannot insert NULL into ("BAAN"."TTFGLD215100"."T$DIM2")
In some situations, we don't use dim2. if I enter the above record via GTM (ttaad4100) it is accepted with nothing in dim2, dim3, etc...
What do I set the "values" for t$dim2 to in order to enter an "empty" field?
Thanks.
trying to insert a null value into say tfgld215.dim2 via an odbc connection to the oracle database;
insert into baan.ttfgld215100
(t$idno, t$dnum, t$lino, t$tcom, t$leac, t$dim1, t$dim2, t$dim3, t$dim4, t$dim5, t$cvat, t$tvat, t$amnt, t$dbcr, t$vamt, t$qty1, t$qty2, t$refr, t$fyer, t$fprd, t$txta, t$imst, t$rprd, t$ryer, t$refcntd, t$refcntu)
values
('robm1234','0','0','100','12345','678','','','','','','','100.00','C','0','0','0','This is a test!','2007','09','0','1','09','2007','0','0')
This yields the following message:
ERROR at line 4:
ORA-01400: cannot insert NULL into ("BAAN"."TTFGLD215100"."T$DIM2")
In some situations, we don't use dim2. if I enter the above record via GTM (ttaad4100) it is accepted with nothing in dim2, dim3, etc...
What do I set the "values" for t$dim2 to in order to enter an "empty" field?
Thanks.