I would store whole cents in the database. EUR 10.99 would be stored as 1099 eurocent. But yes, the mapping is what is missing and what you should look at.
On 05 Mar 2015, at 15:40, Esteban A. Maringolo <emaringolo@gmail.com> wrote:
Can you please share with us how are you defining the mapping for such field?
For what I was able to see in the current implementation the Pharo dialect doesn't provide support for ScaledDecimals. PharoDialect doesn't provide a #fixedPointType, so the number is coerced to a float.
Adding support for it shouldn't be much hassle. Let me see if I can spare a couple of hours to look into this.
See comment of #convertToNumber:for: "Convert to an arbitrary numeric type. Make sure our precision matches. *Hate* floating point"
:)
Esteban A. Maringolo
2015-03-05 11:16 GMT-03:00 Pablo R. Digonzelli <pdigonzelli@gmail.com>:
I know that. the problem is that glorp generates the string in question , not me.
Ing. Pablo Digonzelli Software Solutions IP-Solutiones SRL Metrotec SRL 25 de Mayo 521 San Miguel de Tucumán Email: pdigonzelli@softsargentina.com pdigonzelli@gmail.com Cel: 5493815982714
----- Mensaje original ----- De: "Werner Kassens" <wkassens@libello.com> Para: "Any question about pharo is welcome" <pharo-users@lists.pharo.org> Enviados: Jueves, 5 de Marzo 2015 11:04:01 Asunto: Re: [Pharo-users] scaled decimal number for currency
do you perhaps mean this? b:=ScaledDecimal newFromNumber: 5.8777 scale: 2." 5.88s2" b printShowingDecimalPlaces:2." '5.88'" on a stream you can use 'printOn: aStream showingDecimalPlaces: placesDesired' werner
On 03/05/2015 01:21 PM, Pablo R. Digonzelli wrote:
Hi, I want to use scaled decimal numbers for currency amounts. I am using Glorp too. The problem is that when Glorp generates sql sentences has a problem with #printOn: of ScaledDecimal wich produces output that include the scale value. I do not want to modify printOn: on ScaledDecimal. Any suggestion for this problem?
TIA
**** ------------------------------------------------------------------------ *Ing. Pablo Digonzelli* Software Solutions IP-Solutiones SRL Metrotec SRL 25 de Mayo 521 San Miguel de Tucumán Email: pdigonzelli@softsargentina.com pdigonzelli@gmail.com Cel: 5493815982714