I am using visual studio 2008 Professional / vb.net and sqlserver Express (9.0)
*I am using DAL table adapter logic for db access.

One of my tables needs to have a field changed from smallmoney to decimal (9,2) to accommodate larger values.
After making the changes below, I am now getting the following error when I update, and can't seem to get rid of it....

"SqlDbType.SmallMoney overflow. Value '325008' is out of range. Must be between -214,748.3648 and 214,748.3647."

(If I enter 200,000 the problem goes away.)

I changed the db definition, successfully tested by using realtime sql to enter a large value in the field, redid the xsd, cleaned and rebuilt the solution, deleted the solution .dll and .pdb files, reopened the solution, and recompiled. I've also removed the table/adapter from the xsd, and readded.

I've made many such changes before, without these problems.

Any suggestions will be appreciated.


4 Years
Discussion Span
Last Post by blackbr

Turns out, the problem wasn't with the expanded fields. I needed to expand some other fields that were computed based on the the first fields.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.