Yes sqlite. The book says "SQLite does not handle the decimal type so internally we treat it as a double". However wouldn't it be logical to convert it back to decimal if that is what my tabledef says?
On Jun 17, 6:40 pm, Anthony <abasta...@gmail.com> wrote: > 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. > Seehttp://web2py.com/book/default/chapter/06#DAL,-Table,-Field. > > Anthony