On Friday, June 17, 2011 1:13:26 PM UTC-4, apple wrote: > > I am using the DAL to aggregate SUM a decimal field and the result is > a float. Shouldn't the DAL keep it in same format as the underlying > field?
Are you using SQLite? As far as I know, it doesn't support decimal fields, so I think web2py has to treat them as doubles. See http://web2py.com/book/default/chapter/06#DAL,-Table,-Field. Anthony