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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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