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.SQLCustomType-class.html
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!