When I save a record with a number text input that has 6 digits or more I get an error message:
Microsoft SQL Arithmetic overflow error converting numeric to data type.
The Char on SQL is 50. so I have not exceeded the character limit.
Can you provide the formula that is causing the error, or some screenshots to see what is going on?
Your problem is that you are trying to convert a text value into a value to then have it convert back to a character value for the field.
Remove the Value function from around the TotalCapexAmount_value.Text and try it again. There is no need (from what I see) to do that conversion.
@RandyHayes The conversion is needed as when i remove the value conversion, it says the value not a text is expected.
remember that it works, and only returns the error when I exceeed 5 digits but it accepts anything less.
So then your TotalCapexAmount_value is defined as numeric and not text...that's fine. How is that field defined exactly in the DB?
The Value function does have a maximum and then it starts to round up and down, but from a character perspective, that is about 16 characters - so, that's not where the problem is coming from.
It sounds like you need to increase the precision of the data-type in SQL. In SQL, numeric (and decimal) data types have a definable precision (total number of digits, including decimal places) and scale (number of decimal places) - see this
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand