Just to be sure... Data are entered in english... Mean if we entered exactly this in the form fiel : 123.123
On Wed, Nov 17, 2010 at 3:59 PM, Jonathan Lundell <[email protected]>wrote: > On Nov 17, 2010, at 12:26 PM, mdipierro wrote: > > > > could be. Not sure what that means for decimal numbers. > > FWIW, I took a look at the Python decimal module, and it requires '.' as > the decimal separator. So any conversion is going to have to happen before > Decimal gets the string. > > > > > > On Nov 17, 2:07 pm, Richard Vézina <[email protected]> > > wrote: > >> I use postgresql and local in postgres are : fr_CA.UTF-8 > >> > >> Could it be the reason of the problem? > >> > >> Richard > >> > >> On Wed, Nov 17, 2010 at 2:37 PM, mdipierro <[email protected]> > wrote: > >>> BTW... why are you getting the traceback in french? If your python is > >>> localized, could this affect the meaning of . in sqlite? > >> > >>> On Nov 17, 9:43 am, Richard Vézina <[email protected]> > >>> wrote: > >>>> Hello, > >> > >>>> I wonder if it is normal that I get ticket in that case : > >> > >>>> Model : > >> > >>>> Field('field1','decimal(4,2)'), > >> > >>>> If I insert in form generate with crud.create(db.table1) this value : > >>>> 123.123 > >> > >>>> I get ticket : > >> > >>>> Error traceback > >> > >>>> 1. > >>>> 2. > >>>> 3. > >>>> 4. > >>>> 5. > >>>> 6. > >>>> 7. > >>>> 8. > >>>> 9. > >>>> 10. > >>>> 11. > >>>> 12. > >>>> 13. > >>>> 14. > >>>> 15. > >>>> 16. > >>>> 17. > >>>> 18. > >>>> 19. > >>>> 20. > >>>> 21. > >> > >>>> Traceback (most recent call last): > >>>> File "/web2py/gluon/restricted.py", line 188, in restricted > >>>> exec ccode in environment > >>>> File "/web2py/applications/app/controllers/test.py", line 552, in > >>> <module> > >>>> File "/web2py/gluon/globals.py", line 96, in <lambda> > >>>> self._caller = lambda f: f() > >>>> File "/web2py/gluon/tools.py", line 2270, in f > >>>> return action(*a, **b) > >>>> File "/web2py/applications/app/controllers/test.py", line 372, in > >>> update > >>>> if form.accepts(request.vars, session): > >>>> File "/web2py/gluon/sqlhtml.py", line 1144, in accepts > >>>> self.table._db(self.table.id == self.record.id).update(**fields) > >>>> File "/web2py/gluon/sql.py", line 3484, in update > >>>> self._db._execute(query) > >>>> File "/web2py/gluon/sql.py", line 1026, in <lambda> > >>>> self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > >>>> DataError: ERREUR: champ numérique en dehors des limites > >>>> DETAIL: Un champ de précision 4 et d'échelle 2 doit être arrondi à > une > >>> valeur > >>>> absolue inférieure à 10^2. > >> > >>>> I thought that the validator will show up a error... > >> > >>>> Do I have to use IS_DECIMAL_IN_RANGE and why since I precised the > decimal > >>>> limit in the model??? > >> > >>>> Regards. > >> > >>>> Richard > >> > >> > > >
