Float in jde

[Artur1]

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?

 

[Rauf]

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).

 

[Larry_Jones]

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

 

[BOster]

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.