Error 232

Severity Level 16

Message Text

Arithmetic overflow error for type %s, value = %f.

Explanation

This error occurs when an attempt is made to place a value into a column or variable that cannot be represented by the datatype of the object into which it is being placed. This error prevents the operation from being completed. For example, if you attempt to place the number 32770 into a variable or column defined as type smallint, this error will occur because variables or columns of type smallint can address integers only from -32768 to 32767.

Note Do not confuse this error with operating-system error 232, which occurs when a named pipe connection is closed. Operating-system error 232 is a common communications error.

Action

For numeric operations, you can use the ROUND and CONVERT functions to manipulate the value in question to fit into the column or variable. You can change the datatype of the column or variable in question (for example, in the example described above, you could change the column or variable from smallint to int).