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 <ml.richard.vez...@gmail.com>
> 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 <mdipie...@cs.depaul.edu> 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 <ml.richard.vez...@gmail.com>
>>> 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
>>
>>
