Postgres Pro
Downloads
Home   >   mailing lists

Thread: Setting null to date field from Delphi.

Setting null to date field from Delphi.

From
Terry Yapt
Date:
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.

Re: Setting null to date field from Delphi.

From
"Miguel Juan"
Date:
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
>

Re: Setting null to date field from Delphi.

From
Terry Yapt
Date:
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
>>>>
>>>
>>>
>>>
>>
>>
>
>
>

Re: Setting null to date field from Delphi.

From
Terry Yapt
Date:
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@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>

Re: Setting null to date field from Delphi.

From
Raymond O'Donnell
Date:
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
---------------------------------------------------------------

Re: Setting null to date field from Delphi.

From
Raymond O'Donnell
Date:
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
---------------------------------------------------------------

Re: Setting null to date field from Delphi.

From
"Terry Yapt"
Date:
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@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 6: explain analyze is your
> friend



--

Re: Setting null to date field from Delphi.

From
"Ben Trewern"
Date:
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
>