T
TracyG
Getting this error running a query against an odbc linked sql table
(microsoft sql 2000). The field that was modified went from precision 18
scale 0 to precision 10 scale 4. Existing data was all integers. After
change, entering decimal value data such as 1.5 or .2. The data can be
successfully entered into the table and into the form accessing the
table/field. When viewed, the data initially looks exactly as entered - no
problems. When a query is run against it - get an error "scaling of decimal
value resulted in truncation". From that point forward cannot view the data
and the data line now all says #error
(microsoft sql 2000). The field that was modified went from precision 18
scale 0 to precision 10 scale 4. Existing data was all integers. After
change, entering decimal value data such as 1.5 or .2. The data can be
successfully entered into the table and into the form accessing the
table/field. When viewed, the data initially looks exactly as entered - no
problems. When a query is run against it - get an error "scaling of decimal
value resulted in truncation". From that point forward cannot view the data
and the data line now all says #error