Scaling of decimal value resulted in data truncation

M

MRH

I connect to ans SQLServer 2000 database. When using an expression containing
fields of type decimal in a query, I get the above message, although the
query is a simple select query.
 
B

Brendan Reynolds

Check the precision of the column in the SQL Server database. SQL Server
supports a maximum precision of 38, but the maximum in JET is 28.
 

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

scaling of decimal value resulted in data truncation 0
SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
Scaling decimal value data truncation error 0
error scaling of decimal value resulted in truncation 0
Scaling results in data truncation 2
scaling of decimal value resulted in data truncation 1
Query Message: Scaling of Decimal Value resulted in data Truncatio 3
How to display zero value in blank fields of Cross Tab query 0

Top