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!
