Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting null to date field from Delphi. - Mailing list pgsql-odbc

From Miguel Juan
Subject Re: Setting null to date field from Delphi.
Date
Msg-id 004d01c78e22$3b731ae0$3900a8c0@Despacho
Whole thread Raw
In response to Setting null to date field from Delphi.  (Terry Yapt <yapt@technovell.com>)
List pgsql-odbc
Tree view 
Hi,

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

Regards

Miguel Juan
----- Original Message -----
From: "Terry Yapt" <yapt@technovell.com>
To: <pgsql-odbc@postgresql.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
>

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1003103 ] copy_and_convert_field(...) destroys bind info for wide char varchar columns
Next
From: Peter Eisentraut
Date:
Subject: Re: psqlODBC 08.02.0300 doesn't compile