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

Re: Setting null to date field from Delphi.

From: "Terry Yapt" <yaptNO(at)teSPchAMnovell(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Setting null to date field from Delphi.
Date: 2007-05-15 07:11:02
Message-ID: f2bme3$27us$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Thanks but I am working with TDataSets.  

As I said:
Dataset.FieldByName('datefield').isnull is returning TRUE but when I do
a post to Database then PostgreSQL complaint with error: 22008.

Any another idea ?

Thanks...


"Miguel Juan" wrote:

> 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
> > 
> 
> 
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 6: explain analyze is your
> friend



-- 


In response to

pgsql-odbc by date

Next:From: Terry YaptDate: 2007-05-15 07:14:52
Subject: Re: Setting null to date field from Delphi.
Previous:From: Алексей ЛутовининDate: 2007-05-14 14:45:34
Subject: SQLAllocHandle failed

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