Good afternoon,
I'm having some troubles while trying to use Patch to insert a decimal number into my SQL Database.
The data type of the field is "Numeric(18,2)", and I'd like to insert values like 0,05 or 0,50. Whenever I insert this values using Patch, I get the "Unknown Mashup Exception" error.
On the other side, if the input field is set to Text, it works because I use dot instead of comma (like 0.05), but the database saves only the number and forget the 0's. So for instance, 0.05 becomes a 5.
Is there any way to cast the format number so the database would save it instead of showing me this error?
Thanks in advance.
