FactorySQL Scaling

Archived Topics
1

I’m trying to scale an incoming 3 digit integer to 2 decimal places.
Have turn on scaling
raw 1 scaled .01
raw 100 scaled 1.00

Value of 302 is being scaled to 3 in the database

tried changing the value to a float but no luck still tuncates value to single digit.

Thanks,

Brad

2

When you changed it to a float, did you go and manually change the database column as well? Unfortunately, FactorySQL can’t currently change the db column type for you once it’s created, so it probably is still being stored as an integer.

Try changing the DB column to float as well (or drop the column and let FSQL re-create it as a float) and see if that helps.

Regards,

3

That worked thanks!