[All]
Decimal is out of place with numeric(4,2) and (3,2) via ODBC
Abstract: Decimal is out of place with numeric(4,2) and (3,2) via ODBC
Problem:
Found another problem with the InterSolv ODBC driver. The decimal is
out of
place when the field is defined as numeric (4,2).
Here is how to create the problem:
create table numb (num42 numeric(4,2));
alter table numb add num82 numeric(8,2);
insert into numb values (12.25,12.25)
select * from numb
NUM42 NUM82
====== ===========
12.25 12.25
insert into numb values (10.00, 10.00)
select * from numb
NUM42 NUM82
====== ===========
12.25 12.25
10.00 10.00
Set up an ODBC data source to the database and execute "select * from
numb"
and you see this:
SQLExecDirect:
In: hstmt =
0x00301250, szSqlStr = "select * from numb",
cbSqlStr = -3
Return: SQL_SUCCESS=0
Get Data All:
"NUM42", "NUM82"
1225, 12.25
1000, 10.00
2 rows fetched from 2 columns.
Note: The decimal point is out of place for field num42. and also the
same
for numeric(3,2).
Solution:
One can use other range such as (6,2) and (8,2) to get around the
problem for now.
