"Overflow" Error Message

  • Thread starter Thread starter MB
  • Start date Start date
-----Original Message-----
I am running a select query and getting the "overflow"
error message.
.
I have 60 identical queries with a different criteria in
Click to expand...
each. All 59 other queries work but this one keeps
giving "overflow" message.
 
"Overflow" typically means a number has extended its
allowable range.

For example, an integer is an 16-bit signed number.
Therefore, it's possible values are -32,768 to 32,767. If
you try to assign 100,291 to the integer, it
will "overflow."

Test for these types of conditions and make appropriate
adjustments.

David Atkins, MCP

----------------
High-bit represents sign
00 00 00 00 00 00 00 00 = 0
00 00 00 00 00 00 00 01 = 1
10 00 00 00 00 00 00 00 = -32,768

01 11 11 11 11 11 11 11 = 32,767
11 11 11 11 11 11 11 11 = -1 (NOT 0; aka "True")
 
Back
Top