X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 19118EFFB7 for ; Thu, 5 Jun 2003 03:20:58 +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 76103-09 for ; Thu, 5 Jun 2003 03:20:56 +0000 (GMT) Received: from web14914.mail.yahoo.com (web14914.mail.yahoo.com [216.136.225.241]) by svr1.postgresql.org (Postfix) with SMTP id 11F2CEFFAD for ; Thu, 5 Jun 2003 03:20:56 +0000 (GMT) Message-ID: <20030605032054.97735.qmail@web14914.mail.yahoo.com> Received: from [202.9.168.226] by web14914.mail.yahoo.com via HTTP; Wed, 04 Jun 2003 20:20:54 PDT Date: Wed, 4 Jun 2003 20:20:54 -0700 (PDT) From: "George A.J" Subject: cannot insert zero in to numeric field To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200306/21 X-Sequence-Number: 4232 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