Hi,
I have a Smart Object created from a SQL Server Service instance. One of its return fields is of Decimal type. When a value for this decimal field from the underlying database is too small, I receive the following error when testing the Smart Object in the Tester (the value in the field is 0.00004000):
"Input String was not in a correct format.Couldn't store <4E-05> in Discount column. Expected type is Decimal."
In SQL I have tried casting the output to a float, decimal and numeric - all with higher scales, but none of these seemed to work. I would like to retain the value as a number rather than converting to a varchar, so in doing this, how can I successfully return this field without the above error occurring?
Thanks,
Andy