There is no need to use SQLCustomType in this case. Decimal is supported by web2py type='decimal(n,m)' if the underliying database supports it. The problem is representation of the number.
Try this: class IS_MYDECIMAL(IS_DECIMAL_IN_RANGE): def formatter(self,value): return '%.2f' % value and use the db.table.field.requires=IS_MYDECIMAL(0,100) On Jun 1, 2:24 pm, Michal Jursa <mic...@jursa.cz> wrote: > Hi, > decimal is not directly supported as it is not supported in some db > engines, but you can use SQLCustomType. Example here: > > http://www.web2py.com/examples/static/epydoc/web2py.gluon.sql.SQLCust... > > Michal > > NetAdmin wrote: > > 1. What is the best field choice for currency calculations? > > > I can't find any documentation on the DECIMAL field-type > > even though I saw Field('totalsale', 'decimal(10,2)'), > > while browsing google/groups. > > > 2. Where should I look for the very latest documentation? > > > I defined a field as DOUBLE, but during an an > > edit using SQLFORM, 40.00 shows as 40.0 > > > 3. How can I display 2 decimal places using SQLFORM? > > > I'll switch from sqlite to MySQL if needed. > > > Thanks!