Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ARITHMETIC OVERFLOW ERROR

Status
Not open for further replies.
JUDGE27

JUDGE27

MIS
Joined
Jul 20, 2002
Messages
47
Location
AU
Can anybody shed some light on this error:

ARITHMETIC OVERFLOW ERROR CONVERTING NUMERIC TO DATATYPE NUMERIC


What exactly should I be looking for as the error doesn't exactly specify which field is in breach.

Thanks in Advance


 
Sort by date Sort by votes
look for a number being assigned to a numeric field that is too small to hold a number that size

that's about all we can do for you with the information you've given us

;-)

rudy
 
Upvote 0 Downvote
Or depending on how accurate the error messages are in your database since you did not specify what you are using, a divide by zero error.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soushi01
  • Locked
  • Question Question
Nested Select statement (error output)
Replies
2
Views
337
soushi01
soushi01
soushi01
  • Locked
  • Question Question
Update table Error : single-row subquery returns more than one row
Replies
3
Views
392
PHV
PHV
kory27
  • Locked
  • Question Question
Export to Flat File fails DT_NTEXT ansi error
Replies
1
Views
464
JarlH
JarlH
lesrobot
  • Locked
  • Question Question
Error: Cannot update <field> to Null
Replies
7
Views
330
lesrobot
lesrobot
hpvic03
  • Locked
  • Question Question
Create table error
Replies
2
Views
195
hpvic03
hpvic03

Part and Inventory Search

Sponsor

Back
Top