Until today I did not pay attention to the fact that Servoy creates a double precision data type when I add a numeric field to a table.
When I imported Euro amounts today from a CSV file into a table I use in Servoy, I noticed that some amounts showed up with more than two digits after the point (see screenshot).
Now I worry if that could lead to potential problems in a business software that mainly deals with amounts that have exactly two decimal places.
My feeling is that such amounts should not be stored in double precision fields.
So I would like to ask about experience regarding this matter. Should double precision fields be changed to numeric ones in the data structure?
Especially accounting software must be always exact up to the cent.