Helmut,
instead of:
FieldByName('FIELD').AsDateTime:=0
use:
FieldByName('FIELD').Clear;
Stuart Hunt,
IdeaGen Software Limited

> -----Original Message-----
> From: Helmut Steinberger [SMTP:hs@...]
> Sent: 14 December 2000 09:57
> To: IBObjects@egroups.com
> Subject: [IBO] datetime as NULL
>
> I have a Problem storing a zerovalue for datetimefields.
>
> How can I assign a NULL value to a datetimefield using
> ib_query.fieldbyname?
> When I assign 0 then the value stored is 1899/12/30,
> but I want to store NULL.
>
> cu
> Helmut
>
>
>