From: 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: Fri, 6 Jun 2003 16:47:19 -0700 (PDT)
Message-ID: <20030606234719.55599.qmail@web20808.mail.yahoo.com> (raw)
In-Reply-To: <20030605032054.97735.qmail@web14914.mail.yahoo.com>
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
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: jeff_eckermann@yahoo.com, jinujosein@yahoo.com, pgsql-odbc@postgresql.org
Subject: Re: [INTERFACES] cannot insert zero in to numeric field
In-Reply-To: <20030606234719.55599.qmail@web20808.mail.yahoo.com>
* 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