By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

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.
Any suggestions will be greatly appreciated.

Thank you
Raj

Feb 16 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.