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.