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/co...y/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@technovell.com
> > To: pgsql-odbc@postgresql.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@technovell.com>
> > >>> To: <pgsql-odbc@postgresql.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>


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

On 15/05/2007 15:16, Terry Yapt wrote:

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

I use dbExpress and the Vita Voom driver for PostgreSQL
(www.vitavoom.com) - it's a commercial driver but reasonably proced, and
works very well.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

On 15/05/2007 15:39, Raymond O'Donnell wrote:

> reasonably proced

Oops - that should have been "priced". :-)

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Try ZeosLib here: http://forum.zeoslib.net.ms/

They work well (with a few quirks) and are LGPL free. Use the 6.6.1-beta
versions as they seem to be more stable than a beta.

Regards,

Ben

""Raymond O'Donnell"" <rod@iol.ie> wrote in message
news:4649C620.7060500@iol.ie...
> On 15/05/2007 15:16, Terry Yapt wrote:
>
>> Do you know any other direct postgresql access for VCL besides
>> postgresDAC ?
>
> I use dbExpress and the Vita Voom driver for PostgreSQL
> (www.vitavoom.com) - it's a commercial driver but reasonably proced, and
> works very well.
>
> Ray.
>
> ---------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> ---------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>