Does not accept null values

[Niki_S]

CREATE TABLE C:\Tempfiles\_DelDtl (nStylecode N(10),cAccountNo C(15),cContract C(15),Style C(50),cLotName C(5),cCategory C(15),nCiQty N(10),cShipFty C(5),cColorName C(50),;
cShipMode C(5),dEx_dte D(8),dindc_dte D(8),Destinatn C(50),cPoNo C(15),cSeason C(15),Delvr_Pcs N(10,1),nqty N(10),cStatus C(5))

This is how I create my table. When I run my code it says Delvr_Pcs does not accept null values.
How can I fix this?

Thank you

 

[Chris Miller]

You write Delvr_Pcs N(10,1) NULLable ot Delvr_Pcs N(10,1) NULL to make it nullable.

Or you check how the nulls get in there and avoid them. In such a numeric field I would work with 0.0 as the default, not null.

Chriss

 

[Niki_S]

Thank you for your support