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

Reply via email to