Subject | Re: [firebird-support] Firebird 2.5, FibPlus, Delphi 2010, DateTime field set to Null |
---|---|
Author | Precious So |
Post date | 2013-03-24T10:57:50Z |
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
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]