Subject Re: [firebird-support] Firebird 2.5, FibPlus, Delphi 2010, DateTime field set to Null
Author Precious So
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]