truncation error while linking database

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal Truncation Issue upon Import - Access 2007 1
SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
Linking ODBC table results in Decimal field size for Number type in Access 2002 1
Scaling results in data truncation 2
Scaling of decimal value resulted in data truncation 2
Decimal-error when linking Oracle database tables via ODBC to Acce 1
Split database- linking tables 1
Linking vs Importing using ODBC connected database 1

Top