In the database table decimal are represented like this : 123.123 When I export data the "." is replaced by the comma, but I think that depend of the local of the system or the local I specified in the pgadmin export panel...
What the relation between the local of the database and the and the lenght of the decimal defined in the model? I far as I can see web2py return to the database the proper format it should it only failed to detected the lenght of the entered value. Maybe the local of the naviagator is involved?? I set chrome to french canada. I will make a check in firefox if the problem is not coming from chrome. Richard On Wed, Nov 17, 2010 at 3:26 PM, mdipierro <[email protected]> wrote: > could be. Not sure what that means for decimal numbers. > > 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 > > > > >
