Select Query Resulting in "Scaling of decimal value resulted in data truncation"

[aking]

I'm executing a simple select query against a linked table over a ODBC connection to a postgres server. It is supposed to retrieve a decimal field, which contains values of varying precision. The raw query results in: "Scaling of decimal value resulted in data truncation." I've tried rounding and converting the results in the query to a double, but the error persists. Anyone have any suggestions on how to resolve this? Thanks.

[Rainlover]

You said that the Data has varying precision. Are you sure about this, because a Field in a Table has the precision set once for all records. Or did you mean something different.

Exactly what happens in the query. Namely what do you expect to see and what do you get.