Hello
I have too many decimal fields are in my system.When I save large value it will throw error "Coversion overflow".
Is there any way to handle error without changing model or db ? I want to show the message to user that please enter valid value for the fields.
I want to make generic so i do not want to write for each field.
awaiting for your reply
keyurPosted May 13, 2015, 7:38 AM
keyurPosted May 13, 2015, 1:46 AM
Nanhe SiddiquePosted May 13, 2015, 1:44 AM
Check the target column size for each column where the value is computed by a formula. Consider either expanding the size of the target or rcolumn educing the allowable values in the formula's source columns.
keyurPosted May 13, 2015, 1:43 AM
But I did not get enough idea from the link you given.Can you please tell how to achive this?
Thanks
Munesh SharmaPosted May 13, 2015, 1:34 AM
https://social.msdn.microsoft.com/Forums/en-US/a97e9bcd-b285-4670-9e61-acac4567db6a/conversion-overflow-error-while-mapping-large-decimal-value?forum=adodotnetdataproviders
https://msdn.microsoft.com/en-us/library/system.data.sqltypes.sqldecimal.aspx