M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 58
Registered: ‎11-15-2018

Mobile App inaccuracy with type 'Number'

Hi,

 

We remarked that fields defined as 'Number' are stored wrong if you have big values or float numbers.

 

For example:

 

Input    	Stored Value in Form and database
25.50 		25.50 		-> OK
25.55 		25.549999	-> not OK   
7777777 	7777777  	-> OK
77777777 	77777776	-> not OK   


Our configuration:
Field 'aaa' in database table is configured as float (SQL Server)
We also tested type numeric(12,2), but it's the same behavior.

 

Shell.xaml
<Field Name="aaa" Type="Number" />

 

Form.xaml
<Editor Name="aaa" Title="AAA"/>

 

Is there a better type than 'Number' we can use for?

 

Thank you very much,
regards, Iris