Re: Setting null to date field from Delphi.

[Terry Yapt <yapt(at)technovell(dot)com>]

Thanks but I am working with TDataSets not a TQuery. 

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 escribió:
> > > 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