Hi,
I tried everything, assign a null value onNewRecord event, did not do it.
this is what I have tried,

CREATE DOMAIN T_DATE2 AS DATE DEFAULT NULL;
CREATE TABLE INVOICES (
ORDDATE T_DATE2,

and this, without a domain
CREATE TABLE INVOICES (
ORDDATE DATE,

with dbnavigator I insert a record. when I post the record get the error;
EDataBaseError "field ORDDATE must have a value"
if I give it a value no problem, but what am I doing wrong, if I don't
want to give it a value??
D5,IBO,FB1

what am I not understanding? should I be able to post the record with no
value in it? Why would it not post? only post with a value in the field?

what else can I do?
Daniel