Arithmetic overflow error converting numeric to data type numeric.

Last Post 27 Jan 2010 07:10 AM by JASBRYDEN. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
JASBRYDEN
New Member
New Member

--
27 Jan 2010 06:14 AM

I am trying to do an update on a table


IF ('ASB_VINUDEF' IN (SELECT name FROM Sysobjects WHERE xtype = 'U') )
DROP Table ASB_VINUDEF
GO

CREATE TABLE [ASB_VINUDEF] (
[CCITEM]CHAR (20) NULL,
[CCF003] CHAR (20) NULL,
[CCF004] CHAR (30) NULL,
[CCF010]CHAR (1) NULL,
[CCF011] VARCHAR (4) NULL,
[CCF012] CHAR (2) NULL,
[CCF007] CHAR (7) NULL,
[CCF015] CHAR (20) NULL,
[Litres] decimal (12,4) NULL
)

but getting this error all the time


update ASB_VINUDEF
set litres=ccf011*0.01


Server: Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated.







JASBRYDEN
New Member
New Member

--
27 Jan 2010 06:36 AM
I did that

SELECT * FROM ASB_VINUDEF
WHERE isNumeric(ccf011) = 0


it came up empty.

any ideas what I may be doing wrong?
JASBRYDEN
New Member
New Member

--
27 Jan 2010 07:10 AM
Yes It did


Thanks !!!!!
You are not authorized to post a reply.

Acceptable Use Policy