Re: Setting null to date field from Delphi.

Hello Alvaro and thanks for your answer...

I am using PostgreSQL 8.2.4 DB and I don't know if using previous odbc
versions is an option. (ie: Schemas might be a problem I think).

I agree with you that odbc 8.x.xx has a lot of "rare behaviours" and I
am seriously thinking to get off odbc and buy direct access components
VCL from MicroOlap or something similar:
MicroOlap: http://www.microolap.com/products/connectivity/postgresdac/

I am spending more time checking behaviours and looking for workarounds
than developing software itself.

Do you know any other direct postgresql access for VCL besides
postgresDAC ?

Thanks.

Greetings from Spain...

ALVARO ARCILA escribió:
>
> Hi,
>
> Actually I'm working with Delphi accessing postgresql and I've had
> some kind of problems with recents versions of postgresql odbc....
> I've got the better results with version 7.03.100 ... maybe you can
> switch to this version and try ...
>
> I hope this would help you,
>
> Alvaro Arcila
>
>
> ------------------------------------------------------------------------
>
> > Date: Tue, 15 May 2007 09:14:52 +0200
> > From: yapt(at)technovell(dot)com
> > To: pgsql-odbc(at)postgresql(dot)org
> > Subject: Re: [ODBC] Setting null to date field from Delphi.
> >
> > 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
> > >>>>
> > >>>
> > >>>
> > >>>
> > >>
> > >>
> > >
> > >
> > >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
>
>
> ------------------------------------------------------------------------
> ¡Ya está aquí Windows Live Spaces! Ahora podrás crear fácilmente tu
> propio sitio Web. Pruébalo <http://spaces.live.com/signup.aspx>