truncation error while linking database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am doing some queries on a ORACLE 8i database. I have linked suitable
tables to use the required fields. Now, whenever i use some of these tables,
an error message comes as follows: [ Scaling of decimal value resulted in
data truncation.] I guess this is happening with the tables which have
'Number' fields with large decimals. I am using ACCESS 2000. Can you pls tell
me how to get over this problem?
 
A few thoughts. is this scientific data where you need absolute precision? if
so double data format is never exactly reliable. currency is accurate to 4
decimals i think. you could regard everything as integer if long is big
enough and manipulate yourself. perhaps the back end data formats are not
right.
 
Back
Top