It appears that it get silently "cropped/rounded" by the backend field type configuration... If I have field with 2 places in the backend and 3 places defined in the models and input 0.647, it will be stored as 0.65.
Do we have control over the rounding in web2py or it configure in the database engine?? Richard On Fri, Apr 20, 2018 at 2:30 PM, Richard Vézina <ml.richard.vez...@gmail.com > wrote: > Realize that, though I am sure it use to managed it... > > Anyway, I find it curious that even if I have field of type decimal(10, 2) > for instance, if I insert 1.304, and submit the form it ends up with 1.304 > in the read form (backend has 3 places). > > How do we validated the number of places?? > > Richard > > On Fri, Apr 20, 2018 at 11:32 AM, Anthony <abasta...@gmail.com> wrote: > >> On Friday, April 20, 2018 at 9:38:47 AM UTC-4, Richard wrote: >>> >>> Hello, >>> >>> I was under the impression that IS_DECIMAL_IN_RANGE(2.25, 5.25) would >>> validate and prevent input having more places the number of places of min >>> and max... >>> >> >> No, it just ensures that the value is greater than or equal to the min >> and less than or equal to the max. This validator has nothing to do with >> the number of decimal places. >> >> Anthony >> >> -- >> 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.
