Re: Setting null to date field from Delphi.

Hi,

have a look to the class TParam: TParam.Clear ,TParam.Bound and ftDate

Regards

Miguel Juan
----- Original Message -----
From: "Terry Yapt" <yapt(at)technovell(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Wednesday, May 02, 2007 12:16 PM
Subject: [ODBC] Setting null to date field from Delphi.

>I am working with Delphi 2006 and pgsql-odbc driver 8.02.02.00 to
> 8.02.04.00.
>
> I am trying to set a date field to null. In spite of the boolean value
> of 'Dataset.FieldByName('datefield').isnull' is returning true
> (onBeforePost event), PostgreSQL is complaining with error: 22008 and
> showing the date: '0001-00-00' as the wrong date value.
>
> If someone have any idea it would be very appreciated.
>
> Thanks.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>