Information générale
Titre:
Decimals Missing in SQLEXEC
Versions des environnements
Network:
Windows 2000 Server
H, I am having a problem with decimals.
Basically in DB2 I made a table like this:
drop table uw.test;
create table uw.test (n1 decimal(9,4),n2 decimal(9,3),n3 decimal(9,3),n4 decimal(9,4),n5 decimal(9,4));
insert into uw.test values (1.900,1.900,1.900,1.900,1.900);
Then on 1 client I select the table with ODBC using:
sqlexec(h,'select * from uw.test','test')
then if I do a
?n1
It returns 1.000 the decimals are missing!!
If I browse the table I see the values as 1.9 in all the field
except when I tab into each field the value changes to 1.0 if I retype the value then it stays in the field the next time I tab.
This only happens on "their" clients on my PC this works fine?
Anyone have any ideas?
BR
Tim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement