From: Mike S. <ms...@md...> - 2007-02-20 13:03:48
|
Sounds like currencyAmount DECIMAL(x,4) seems to meet everyone's needs, so I'll add that momentarily ... ms On Feb 20, 2007, at 4:39 AM, Georg Tuparev wrote: > Mike, > > After working on banking projects for few years, I've learned (the > hard way) that most transactions are DECIMAL(xx,3). I've seen also > transaction systems that work with DECIMAL(xx,5)... butt 3 will > probably cover 99% of the cases... > > gt > > > On Feb 20, 2007, at 2:47 AM, Mike Schrag wrote: > >> I'm voting for adding a "currencyAmount" prototype that is valueType >> = B, DECIMAL(38,2), btw. Speak now (or soon) or forever hold your >> peace. Changing the definition seems a little scary for everyone. >> However, FrontBase is just wrong (compared to the others), so I >> believe FrontBase's "amount" definition should change to value type >> "d" to match everyone else. >> >> ms > > Georg Tuparev > Tuparev Technologies > Klipper 13 > 1186 VR Amstelveen > The Netherlands > Mobile: +31-6-55798196 > |