Обсуждение: 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.
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
>
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
>>>>
>>>
>>>
>>>
>>
>>
>
>
>
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>
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 ---------------------------------------------------------------
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 ---------------------------------------------------------------
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
--
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 >