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