From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>, "George A(dot)J" <jinujosein(at)yahoo(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] cannot insert zero in to numeric field |
Date: | 2003-06-09 08:40:33 |
Message-ID: | 3EE44801.FB4D4563@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-odbc |
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(at)yahoo(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Gardner | 2003-06-09 15:42:25 | Re: Some quick notes about extending libpq for new protocol |
Previous Message | Jeff Eckermann | 2003-06-06 23:47:19 | Re: [INTERFACES] cannot insert zero in to numeric field |
From | Date | Subject | |
---|---|---|---|
Next Message | Julie May | 2003-06-09 15:12:32 | Re: pgsql-odbc bug querying VIEWs - Possible Solution |
Previous Message | Frankie Lam | 2003-06-07 04:23:15 | Connect Timeout Does Not Work |