You usually get this error message when the field is not large enough to contain the value. Like storing 1000.00 into a N(6, 2) field.

HTH

>How to avoid numeric overflow and I use "set decimal to 2" but the error still going on.