MS SQL Server - sqlEx = {"Error converting data type numeric to numeric."}

Author

sqlEx = {"Error converting data type numeric to numeric."}

rajmadangopal@gmail.com

2006-02-15, 8:23 pm

Hello Everyone
I am getting the following error when i try to insert a record into Sql
Server 2005 from my VB 2005 application.

sqlEx = {"Error converting data type numeric to numeric."}

I checked for possible overflow exception, but did not encounter any.

I have declared the values that i am trying to insert as DECIMAL data
types in my VB code.

Any suggestions will be greatly appreciated.

Thank you
Raj

dotNetDeveloper

2006-02-16, 9:23 am

Hi
I have some more information on the error
The problem occurs when the decimal value has 6 digits before the
decimal.
The precision for the column has been specified as 20 and scale as 2.
I used in-place editing available in VS 2005 to change the value to 5
digits before the decimal and it let me insert the record.
I also used the same values to try inserting directly via a sql query
and it worked.
So, any suggestions will be greatly appreciated.

Thank you
Raj

*** Sent via Developersdex http://www.droptable.com ***

Sponsored Links