X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 8C576EFF98
	for <pgsql-odbc-postgresql.org@localhost.postgresql.org>;
	Fri,  6 Jun 2003 23:47:18 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 27533-03
	for <pgsql-odbc-postgresql.org@localhost.postgresql.org>;
	Fri,  6 Jun 2003 23:47:17 +0000 (GMT)
Received: from web20808.mail.yahoo.com (web20808.mail.yahoo.com
	[216.136.226.197])
	by svr1.postgresql.org (Postfix) with SMTP id 8CD50EFF72
	for <pgsql-odbc@postgresql.org>; Fri,  6 Jun 2003 23:47:16 +0000 (GMT)
Message-ID: <20030606234719.55599.qmail@web20808.mail.yahoo.com>
Received: from [68.105.48.176] by web20808.mail.yahoo.com via HTTP;
	Fri, 06 Jun 2003 16:47:19 PDT
Date: Fri, 6 Jun 2003 16:47:19 -0700 (PDT)
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
Subject: Re: [INTERFACES] cannot insert zero in to numeric field 
To: "George A.J" <jinujosein@yahoo.com>
Cc: pgsql-odbc@postgresql.org
In-Reply-To: <20030605032054.97735.qmail@web14914.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200306/17
X-Sequence-Number: 2991

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