Hello,

I am trying to update dabo from version 0.9.3 to a newer one, currently
0.9.9 but 0.9.5 doesn't work neither.

The code that worked fine in version 0.9.3 and now creates the error is
the following:

tmpCursor               = self.Form.PrimaryBizobj.getTempCursor()

tmpCursor.execute("SELECT rechnung_position.name, preis, anzahl FROM
rechnung INNER JOIN rechnung_position ON rechnung.id=rechnung_id WHERE
re     chnung.id=%i ORDER BY position" %
(self.Form.getBizobj("rechnung").getPK()))

ds_artikel              = tmpCursor.getDataSet()


Here the complete error:

Traceback (most recent call last):
  File
"/home/max/projekte/kolibrill/dabo/dabo/ui/uiwx/dControlMixin.py", line
27, in _onWxHit
    self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
  File "/home/max/projekte/kolibrill/dabo/dabo/ui/uiwx/dPemMixin.py",
line 1074, in raiseEvent
    super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
**kwargs)
  File "/home/max/projekte/kolibrill/dabo/dabo/lib/eventMixin.py", line
81, in raiseEvent
    bindingFunction(event)
  File "/tmp/tmpseTPdZ.py", line 4987, in onHit
    ds_artikel          = tmpCursor.getDataSet()
  File "/home/max/projekte/kolibrill/dabo/dabo/db/dCursorMixin.py", line
1397, in getDataSet
    _correctFieldTypesIfNeeded(rec)
  File "/home/max/projekte/kolibrill/dabo/dabo/db/dCursorMixin.py", line
219, in _correctFieldTypesIfNeeded
    rec[fld_name] = _correctFieldType(rec[fld_name], fld_name)
  File "/home/max/projekte/kolibrill/dabo/dabo/db/dCursorMixin.py", line
278, in _correctFieldType
    return dec.quantize(Decimal("0.%s" % (scale * "0",)))
  File "/usr/lib/python2.6/decimal.py", line 2358, in quantize
    'quantize result has too many digits for current context')
  File "/usr/lib/python2.6/decimal.py", line 3778, in _raise_error
    raise error(explanation)
decimal.InvalidOperation: quantize result has too many digits for
current context

It somehow seems that the conversion of the database float-field "preis"
or the integer-field "anzahl" fails, but why? I use a mysql-backend if
that is important to know. 

Has anybody an idea what can cause my problem?

Thanks in advance

Max

_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/1367334231.5128.22.camel@max

Reply via email to