Can you change "float" to "double" and try if it fixed the issue?
Marin
On Fri, Aug 15, 2014 at 10:31 AM, Stefan van den Eertwegh <
stefan.eertw...@gmail.com> wrote:
> db.define_table(
> 'invoice_rule',
> Field('invoice', db.invoice, label=T('Invoice no.')),
> Field('amount', 'float', label=T('Amount')),
> Field('product', 'float', label=T('Product'),
> requires=IS_EMPTY_OR(IS_IN_DB(db, db.product.id, db.product._format))),
> Field('description', 'string', label=T('Description')),
> Field('date', 'date', label=T('Date')),
> Field('vat_percentage', 'string',
> requires=IS_IN_SET(settings.vat_percentage), label=T('VAT')),
> Field('quantity', 'float', label=T('Quantity'))
> )
>
>
> Met vriendelijke groet,
> Stefan van den Eertwegh
>
>
> 2014-08-15 10:26 GMT+02:00 Marin Pranjić <marin.pran...@gmail.com>:
>
>> Can you show us your table definition?
>> Web2py doesn't have float. There are double and decimal field types.
>> You don't need to use postgres.
>>
>> Marin
>>
>>
>> On Fri, Aug 15, 2014 at 10:22 AM, Stefan van den Eertwegh <
>> stefan.eertw...@gmail.com> wrote:
>>
>>> I use in the model the type float and MySQL as backend database and
>>> MySQL uses INT() as datatype for that field....
>>>
>>> So i must use decimal(10,2) as field type in the model and as backand db
>>> postgres?
>>>
>>> Op donderdag 14 augustus 2014 21:39:56 UTC+2 schreef Cliff Kachinske:
>>>>
>>>> What database?
>>>>
>>>> Web2py has a decimal datatype which, in my use cases, mimics the Python
>>>> decimal datatype. I use Postgresql and the adapter turns Python decimal
>>>> into Postgres numeric. Both of these types act like real world decimal
>>>> numbers. In other words, .2 + .1 comes out to .3. Of course a different db
>>>> backend may work differently.
>>>>
>>>> Just google python decimal.
>>>>
>>>> On Friday, July 11, 2014 5:50:30 AM UTC-4, Stefan van den Eertwegh
>>>> wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> I have a float type in the define tables and when he inserts 3.50 into
>>>>> the database he makes 4.0 off it.
>>>>> How comes that it rounds off the float? And not uses the usage of 2
>>>>> decimals?
>>>>>
>>>>> Thank you!
>>>>>
>>>> --
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to web2py+unsubscr...@googlegroups.com.
>>>
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/IUs0Zjgmseo/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
