Re: ODBC "No Rows Affected" for floating point number in Oracle

Try :
alter session set NLS_NUMERIC_CHARACTERS='.,' If that solves the problem, and your Server is on NT, you can set this in the registry on the server (search for NLS_LANG) an bounce the instance.
The ODBC driver should be OK, previous ODBC drivers from Oracle (8.1.5 and 8.1.6.0) I could not get to work this way. If not, try the MS ODBC driver for Oracle.

Hth,

Ted

On 5 Jun 2001 04:10:41 -0700, niklas.lindvald_at_noventus.se (Niklas Lindvald) wrote:

>I have a problem with the ODBC driver for Oracle when I am trying to
>update a float column.
>
>Database: Oracle 8.0.4.0
>ODBC driver: Oracle 8.01.63.00
>
>I am using the cursor library, and MFC recordsets with RFX_Single for
>the float columns.
>
>The database test table looks like:
>CREATE TABLE Test (
> lKey NUMBER(10) NOT NULL,
> fFloat FLOAT(23) NULL
>);
>
>Inserting into the table is no problem, but when I am trying to update
>a row I get the error 'No rows were affected by the update or delete
>operation.'
>This only happens when I am trying to update a row with a float value
>that was previously saved with decimals (e.g. 0.13) in the database (I
>think). Rows with float values with no decimals are ok to update.
>Whether the update will go through or not depends on what was earlier
>saved in the floating point column - certain numbers cannot be
>updated.
>Since I am the only one using the database, it is not a problem of
>someone else updating the table between my fetch and update.
>
>When I turn off the cursor library, there are no problems with this.
>If I change the size of the float in the database table to 47 or
>higher it also works fine.
>
>I have also tried the Intersolv 3.10 and Merant 3.60 ODBC drivers. The
>Merant 3.60 driver is just like the Oracle driver - do not work with
>floats unless the size is 47 or higher. The Intersolv 3.10 is the
>other way around - works well if the float column is of size 46 or
>less, otherwise not.
>
>Any suggestions what to do to make it work with Oracle ODBC and cursor
>library?
>
>Thanks
>Niklas Lindvald

EMail: knijff_at_bigfoot.com Received on Sat Jun 09 2001 - 08:53:22 CDT