Skip site navigation (1) Skip section navigation (2)

Setting null to date field from Delphi.

From: Terry Yapt <yapt(at)technovell(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Setting null to date field from Delphi.
Date: 2007-05-02 10:16:08
Message-ID: 463864E8.1030400@technovell.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

Responses

pgsql-odbc by date

Next:From: noreplyDate: 2007-05-03 07:56:43
Subject: [ psqlodbc-Bugs-1003103 ] copy_and_convert_field(...) destroys bind info for wide char varchar columns
Previous:From: Hiroshi SaitoDate: 2007-05-02 05:32:24
Subject: Re: REQUEST HELP : Documentation on ODBC installation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group