Do you need to keep existing data?
If you don't, the easiest solution would be to drop affected tables, remove
their *.table files (stored in databases directory), and let web2py
recreate it.
If you need to keep the data, but you don't care about those float/double
fields, you can manually change those fields.
[I wonder why web2py didn't automigrate...]
On Fri, Aug 15, 2014 at 10:42 AM, Stefan van den Eertwegh <
stefan.eertw...@gmail.com> wrote:
> Yes, that fixed the issue. but only for a new field, it adds the new field
> in mysql as type double.
> If i change a current field in the model to double than it stays as int in
> mysql.
>
> Shall i change the fields manually in mysql?
>
> Op vrijdag 15 augustus 2014 10:35:49 UTC+2 schreef Marin Pranjić:
>>
>> 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....@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....@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....@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+un...@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+un...@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+un...@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.
