But if you don't store anything, wouldn't this be considered as NULL?
If you have Table (ID,DATETIME), then
Insert();
FieldByName("ID")->AsInteger=2;
Post();

Riho-Rene Ellermaa
senior programmer
Hansabank

> -----Original Message-----
> From: Helmut Steinberger [mailto:hs@...]
> Sent: Thursday, December 14, 2000 11:57 AM
> 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
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> Make FREE long-distance calls with Tellme!
> Just dial 1-800-555-TELL.
> http://click.egroups.com/1/10794/1/_/685810/_/976787769/
> --------------------------------------------------------------
> -------_->
>
>
>