All right, I knew about the implied decimal point solution but it won allow you to handle very big numbers.
I made a quick check and only SQLite doesn't support DECIMAL types. Maybe is worth the effort to make DAL support, for the sake of simplicity, a MONEY type and make DAL to 'internaly' support decimal types in SQLite with implied decimal point. On 21 mar, 03:45, mdipierro <[email protected]> wrote: > try this: > > class IS_DECIMAL: > def __init__(self,decimals=2,error_message="Invalid"): > self.decimals=decimals > self.error_message=error_message > def __call__(self,value): > try: > value=int(float(value)*(10**self.decimals)) > return (value,None) > except: > return (value,self.error_message) > def format(self,value): > return float(value)/10**self.decimals > > On Mar 20, 7:41 pm, Joe Barnhart <[email protected]> wrote: > > > The easiest workaround is to use INTEGER and leave all amounts in > > cents, i.e. 123 instead of 1.23. If all math is done with the implied > > decimal point on integers, you will never have floating-point round- > > off errors. Only put in the decimal point when you are ready to > > display the value. (Massimo -- Maybe a validator can help here?) > > > -- Joe B. > > > On Mar 20, 12:03 pm, Paco <[email protected]> wrote: > > > > I've been trying web2py for a couple of days and I believe is just > > > great. I'm so excited that I'm planning to build my own accounting and > > > invoicing application, which is, in the other hand, not so complex in > > > my case. > > > > I need (and I believe many more people do) a DECIMAL field type or > > > maybe a CURRENCY type since there are many applications that need > > > fixed precision numbers. > > > > It seems to me that is shouldn't be very difficult to do since most > > > databases, including SQLite, support NUMERIC or DECIMAL types. > > > > It would be a great newfeature. Are there any plans to do such a > > > thing? Or maybe there is a nice workaround to do this in web2py? > > > > Cheers, > > > Paco > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
