From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: George A.J <jinujosein@yahoo.com>
Cc: pgsql-odbc@postgresql.org
Subject: Re: [INTERFACES] cannot insert zero in to numeric field
Date: Mon, 09 Jun 2003 17:40:33 +0900
Message-ID: <3EE44801.FB4D4563@tpf.co.jp> (raw)
References: <20030606234719.55599.qmail@web20808.mail.yahoo.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Inoue@tpf.co.jp, jeff_eckermann@yahoo.com, jinujosein@yahoo.com, pgsql-odbc@postgresql.org
Subject: Re: [INTERFACES] cannot insert zero in to numeric field
In-Reply-To: <3EE44801.FB4D4563@tpf.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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