Wolfgang,

Check your field if you configure it if you allow null value.

Try this query if will work.
Upate vi_master set date_paid ='' where record no=12

Let me know if its working.

Precious

On Mar 24, 2013 8:58 AM, "Wolfgang Kluge" <wkluge@...> wrote:

> **
>
>
> Good morning.
>
> I need to set a DateTime field which has already a valid DateTime value
> to Null and have no idea how to do this.
>
> Query.Params[10].AsDateTime := Null; <--------------
> compiler error
> Query.ExecQuery;
>
> With IBEasy 1.5.3 the following does work:
>
> update VI_Master set Date_Paid = Null where record_no = 12
>
> I will greatly appreciate any hint how to go about it.
>
> Regards
> Wolfgang Kluge
>
>
>


[Non-text portions of this message have been removed]