>Hi
>How to replace date field with null value ?
>sqlexec(lnHandle,"update item set date_out=?m.NULL where date_in=current_date")

myDate = cast(null as date)
sqlexec(lnHandle,"update item set date_out=?m.myDate where date_in=current_date")

sqlexec(lnHandle,"update item set date_out=null where date_in=current_date")

Cetin