pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedcannot insert zero in to numeric field
3+ messages / 3 participants
[nested] [flat]
* cannot insert zero in to numeric field
@ 2003-06-05 03:20 George A.J <jinujosein@yahoo.com>
2003-06-06 23:47 ` Re: [INTERFACES] cannot insert zero in to numeric field Jeff Eckermann <jeff_eckermann@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: George A.J @ 2003-06-05 03:20 UTC (permalink / raw)
To: pgsql-interfaces
i am usig postgres with VB (ADO using ODBC). when i
try to update a numeric field in a table with zero an
error occurs "ERROR: Bad numeric input format '.' " .
this happends when i call recordset.update() after
assigning 0 to the field. a sample is given bellow
rs!Opening=0
rs.Update
this code works fine if we assign any value other than
zero to the field.is there a solution. or is it a bug?
if i use the update query there is no problem.
pls help
thanks...
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] cannot insert zero in to numeric field
2003-06-05 03:20 cannot insert zero in to numeric field George A.J <jinujosein@yahoo.com>
@ 2003-06-06 23:47 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
2003-06-09 08:40 ` Re: [INTERFACES] cannot insert zero in to numeric field Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 1 reply; 3+ messages in thread
From: Jeff Eckermann @ 2003-06-06 23:47 UTC (permalink / raw)
To: George A.J <jinujosein@yahoo.com>; +Cc: pgsql-odbc@postgresql.org
I am sending your message to the pgsql-odbc list,
because you are more likely to get help there.
Sorry, I don't have an answer for you...
--- "George A.J" <jinujosein@yahoo.com> wrote:
>
> i am usig postgres with VB (ADO using ODBC). when i
> try to update a numeric field in a table with zero
> an
> error occurs "ERROR: Bad numeric input format '.' "
> .
> this happends when i call recordset.update() after
> assigning 0 to the field. a sample is given bellow
>
> rs!Opening=0
> rs.Update
>
> this code works fine if we assign any value other
> than
> zero to the field.is there a solution. or is it a
> bug?
>
> if i use the update query there is no problem.
>
> pls help
>
> thanks...
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to
> Outlook(TM).
> http://calendar.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] cannot insert zero in to numeric field
2003-06-05 03:20 cannot insert zero in to numeric field George A.J <jinujosein@yahoo.com>
2003-06-06 23:47 ` Re: [INTERFACES] cannot insert zero in to numeric field Jeff Eckermann <jeff_eckermann@yahoo.com>
@ 2003-06-09 08:40 ` Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 0 replies; 3+ messages in thread
From: Hiroshi Inoue @ 2003-06-09 08:40 UTC (permalink / raw)
To: Jeff Eckermann <jeff_eckermann@yahoo.com>; George A.J <jinujosein@yahoo.com>; +Cc: pgsql-odbc@postgresql.org
Jeff Eckermann wrote:
>
> I am sending your message to the pgsql-odbc list,
> because you are more likely to get help there.
> Sorry, I don't have an answer for you...
Please try the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/ .
> --- "George A.J" <jinujosein@yahoo.com> wrote:
> >
> > i am usig postgres with VB (ADO using ODBC). when i
> > try to update a numeric field in a table with zero
> > an
> > error occurs "ERROR: Bad numeric input format '.' "
> > .
> > this happends when i call recordset.update() after
> > assigning 0 to the field. a sample is given bellow
> >
> > rs!Opening=0
> > rs.Update
> >
> > this code works fine if we assign any value other
> > than
> > zero to the field.is there a solution. or is it a
> > bug?
> >
> > if i use the update query there is no problem.
> >
> > pls help
> >
> > thanks...
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-06-09 08:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-06-05 03:20 cannot insert zero in to numeric field George A.J <jinujosein@yahoo.com>
2003-06-06 23:47 ` Jeff Eckermann <jeff_eckermann@yahoo.com>
2003-06-09 08:40 ` Hiroshi Inoue <Inoue@tpf.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox