Good morning.
Sorry, it does not work, the compiler issues an error.
Regards
Wolfgang Kluge

On 03/24/2013 06:57 PM, Precious So wrote:
> 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]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>