>mystr = "Insert into mastcust (masterref,amenddate) values('0000000001',?m.mydate)" >sqlprepare(handle,mystr) && Ok so far > >***m.mydate = date() >** If you didn't care about time portion, the DATE portion of this field is used only for info >m.mydate = DATETIME() >** but if the DATE portion of this field is used for some calculations: >m.mydate = DATETIME(YEAR(DATE(), MONTH(DATE(), DAY(DATE(),0,0,0) >retval = sqlexecute(handle) >IF retval < 0 > AERROR(arError) > DISPLAY MEMO LIKE arError >ENDIF >