Thread: ODBC Bug. Bad numeric input format ?

"George A.J" wrote:
>
> Hi all,
>
> 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. i think it is a bug?
>
>  if i use the update query there is no problem.
>
> the same same problem exist if a adodb.command object is used to call
> a function
> in pl/pgsql. The problem exist only for numeric filed. if a non zero
> digit exist before decimal point the code works correctly. if we send
> the value 0.0001 it is reached in postgres as .1. ie the numeric value
> is changed when it reached the backend. i get this from the query log
> of postgresql. if we send a zero (0.00) it reached back end as "."
> that is why the error bad numeric input.
> how can i solve this bug.
> where should i report this?
> i tried the latest snapshot dll of ODBC  7.03.0115 but the error still
> exist.

Hmm strange, the bug seems to be fixed at least in the
current snapshot. Could you send me the Mylog debug output ?

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/