another option is when you call your sql statement to cast it into float datatype and in nave you can assign that into a decimal value.
another option is when you call your sql statement to cast it into float datatype and in nave you can assign that into a decimal value.