SQL ERROR IN SELECT STATEMENT

[JOEY]

Hi,

I am getting an error 8417.."scale of a numeric data value was truncated".

It's occuring on a simple select statement where a table field is being
"SELECT"ed into a table defined field
The field has the following characteristics
FIELDA NUMERIC (6,2) UNSIGNED NO DEFAULT NOT NULL,

The select statement works when the value is an integer number EX:2
But returns the error when it's a whole number EX: 2.57

Anybody have any ideas???????

[Simon Sellick]

"JOEY" <JOSEPH.VICTORIA@EMERGIS.COM> wrote:
>
>Hi,
>
>I am getting an error 8417.."scale of a numeric data value was truncated".
>
>It's occuring on a simple select statement where a table field is being

>"SELECT"ed into a table defined field
>The field has the following characteristics
>FIELDA NUMERIC (6,2) UNSIGNED NO DEFAULT NOT NULL,
>
- is this the source or the destination? how does it compare with the other
one?

>The select statement works when the value is an integer number EX:2
>But returns the error when it's a whole number EX: 2.57
>
- do you mean when it's NOT a whole number? and might this be a rounding
problem - i.e. the value is really something like 2.569, so it has to be
truncated to fit the destination?

>Anybody have any ideas???????
>