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 gkittelson 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
Jul 20, 2002
47
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
Nested Select statement (error output) 1
Replies
2
Views
115
soushi01
soushi01
soushi01
  • Locked
  • Question
Update table Error : single-row subquery returns more than one row
Replies
3
Views
126
PHV
PHV
kory27
  • Locked
  • Question
Export to Flat File fails DT_NTEXT ansi error
Replies
1
Views
210
JarlH
JarlH
lesrobot
  • Locked
  • Question
Error: Cannot update <field> to Null
Replies
7
Views
86
lesrobot
lesrobot
hpvic03
  • Locked
  • Question
Create table error
Replies
2
Views
62
hpvic03
hpvic03

Part and Inventory Search

Sponsor

Back
Top