Member Avatar for blackbr

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.

Randy

  • 1 Contributor
  • 1 Reply
  • 177 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by blackbr
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.