Home > mailing lists

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

From	Terry Yapt
Subject	Setting null to date field from Delphi.
Date	May 2, 2007 10:40:12
Msg-id	463864E8.1030400@technovell.com Whole thread Raw
List	pgsql-odbc

Tree view

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.

pgsql-odbc by date:

From: "Hiroshi Saito"
Date: 02 May 2007, 05:32:27
Subject: Re: REQUEST HELP : Documentation on ODBC installation

From:
Date: 03 May 2007, 07:56:49
Subject: [ psqlodbc-Bugs-1003103 ] copy_and_convert_field(...) destroys bind info for wide char varchar columns

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

Previous

Next