Hello mohamed, you wrote on Tue, 5 Nov 2019 18:54:38 +0000:
> Firebird field NUMERIC(8,2) is mapped automatically as integer in > MSEGUI? What is the correct mapping 8.2 looks somewhat like a currency designation, a 10 digit real value with 2 decimal places. Scaled by 100 it fits comfortably into a 32 bit integer value without any loss of precision, as a 32 bit "single" would suffer from. Maybe the fpc "currency" type might do? This is an integer type (64 bit), that's internally mapped to represent a number scaled by 1/10000, which amounts to 4 decimal places and around 15 integer digits, i.e. 19 valid digits altogether. A bit of overkill, but this type is "natively" supported by fpc, when you would have to create a full set of operators yourself if you wanted to use a specifically taylored type of your own. > I am using FB3 connection. Isn't such a declaration usually a parametrized type? I.e, you could just as well declare a field type being NUMERIC(12.3) oder NUMERIC(5.1), or any other fixed point size? Fixed point means a constant-power-of-10 scaling as specified by the number of decimal places. This can easily be represented by an integer of sufficient size, requiring only a simple transformation for retrieval, storing and multiplication type operations, as well as for external representation (displaying or printing). I hope this can be of some help. -- -- (Weitergabe von Adressdaten, Telefonnummern u.ä. ohne Zustimmung nicht gestattet, ebenso Zusendung von Werbung oder ähnlichem) ----------------------------------------------------------- Mit freundlichen Grüßen, S. Schicktanz ----------------------------------------------------------- _______________________________________________ mseide-msegui-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
