X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7C13B311CF2 for ; Tue, 10 Jun 2003 02:48:03 +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 13573-09 for ; Mon, 9 Jun 2003 23:47:53 -0300 (ADT) Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by svr1.postgresql.org (Postfix) with SMTP id 2343030FD8F for ; Mon, 9 Jun 2003 08:36:13 +0000 (GMT) Received: (qmail 24985 invoked from network); 9 Jun 2003 08:36:12 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.tpf-fw-c.co.jp with SMTP; 9 Jun 2003 08:36:12 -0000 Received: from tpf.co.jp ([126.0.1.65]) by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id RAA07521; Mon, 9 Jun 2003 17:36:11 +0900 (JST) Message-ID: <3EE44801.FB4D4563@tpf.co.jp> Date: Mon, 09 Jun 2003 17:40:33 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Jeff Eckermann , "George A.J" Cc: pgsql-odbc@postgresql.org Subject: Re: [INTERFACES] cannot insert zero in to numeric field References: <20030606234719.55599.qmail@web20808.mail.yahoo.com> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200306/18 X-Sequence-Number: 2992 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" 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/