Subject | Firebird 2.5, FibPlus, Delphi 2010, DateTime field set to Null |
---|---|
Author | Wolfgang Kluge |
Post date | 2013-03-24T00:58:11Z |
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
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