Float in jde


Why is float used everywhere in jde for fields that clearly need to be integer? It's a local craft. I have a pattern break, float is a new word in optimization?


  • 2022-07-29 17_35_05-Zoom.png
    2022-07-29 17_35_05-Zoom.png
    11.1 KB · Views: 6


VIP Member
In general, my thinking is, we can convert a float to an integer. But we cannot convert an integer to float.
So its like providing the highest possible facility so that it can be used later ( in any case).


Legendary Poster
JDE with Oracle DB uses Numeric and integer data types. With SQL Server implementation the developers picked float for some reason.


Legendary Poster
I would like to know why they picked float for MSSQL. I would think that some type of integer would have been WAY more efficient with better performance. As a straight 100% guess, I wonder if they thought at some point they would store the actual value instead of the implied decimal position.