+ Start a Discussion
Norm Sherman SFNorm Sherman SF 

Phantom Int / Decimal

Hi All,


Here is a real kicker!


I have a Number field defined as 18,0, which should by definition should not include decimal places.


When I use the frontend to enter a new value, it displays perfectly fine with no decimal places.


However when I perform a SOQL query I am getting a single decimal place, i.e. 11.0, 12.0, 13.0 instead of 11, 12, 13.


This also occurs when I use the web servers API and it is causing my external processes grief because the field should be INT.


What could be the cause for having mixed convesion between the frontend and backend?