Re: FW: ERROR: Bad numeric input format '.' on insert or update

This bug may be fixed in cvs.
Please try the snapshot dll at
    http://www.geocities.jp/inocchichichi/psqlodbc/ .

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

Steve Johnson wrote:
>
> ODBC driver version: 07.03.0100 (ODBC 3 driver)
> PostgreSQL database version: 7.3.2
> Error message: ERROR:  Bad numeric input format '.'
>
> When I attempt to add or update a a row with a numeric(15,2)
> column with a value of 0 (zero) or null, I get this error
> message.  If I change the value to anything else (.01, 1000), the
> insert and update work.
>
> Using psql, I am able to insert and update rows with numeric
> values of 0 without an error.
>
> If I drop back to the psqlodbc legacy 2.5 driver, I do not get
> the error.
>
> I get the error when using the Unicode (beta) driver and the ODBC
> 3 driver.
>
> My application uses VB6 ADODB recordsets with MDAC 2.7.
>
> For a test case, it should be pretty easy to duplicate.  Create a
> table with one numeric(15,2) numeric column.  Use psql to insert
> a row with a value of zero for the column.  Now try to do the
> same thing through psqlODBC ODBC 3.0 driver and you'll get the
> error.  If you try to update that row in that table with a value
> of zero, you'll get the error as well.
>
> The partial ODBC trace log starting with the problem column:
>