>also i want to know, if my date is empty it will insert 01/01/1900. there is a way to put null of something else ???
>thansk
Yes, if date is empty SQL Server put 1 jan 1900 :-( That's why all our DateTime fields allow null, you could do something like this:

TEXT TO SQLCOMMAND NOSHOW PRETEXT 7
     INSERT INTO TB_ARINV (TR_ZEBRAINVID       ,TR_DUEDTE)
                   VALUES (<<ARINV.ZEBRAINVID>>,?IIF(EMPTY(ARINV.DUEDTE),NULL,DTOS(ARINV.DUEDTE)))
ENDTEXT