Arithmic error

Article View: borland.public.cppbuilder.database.ado

Article #1397

Back to borland.public.cppbuilder.database.ado Previous Next

#1397

From: James Peterson
Date: Thu, 08 Jul 2004 13:32

21 lines
1584 bytes

 I am getting the following error when I do an insert into.
Arithmetic overflow error converting numeric to data type numeric

my table is set up like this
Create Table data(
RecNumber int IDENTITY(1,1),
ItemNumber char(30),
CupWeight numeric(6,4),
Primary key(RecNumber))

and my insert is the following

instert into data(ItemNumber, CupWeight)values('itemnumber','182')

if I just insert the item number it works fine but when I add the cupweight
I get the error. I have been doing some searches on the web but they all say
you get that error when you pass a value to large for the field. But as you
can see in this case my number I am passing into cupweight is not exceeding
the limits of the feild.

any help would be greatfull.

Technical Details

Message-ID: <40ed4c75$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,334e5cafbfb3ec2c,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "James Peterson" <jpeterson@romanmealmilling.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Arithmic error
Date: Thu, 8 Jul 2004 08:32:32 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 64.21.236.129
Message-ID: <40ed4c75$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1089293429 64.21.236.129 (8 Jul 2004 06:30:29 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail