Here are the relevant log entries from dabo/dabo/db/dBackend.py from my
involvement in this problem:
------------------------------------------------------------------------
r2359 | paul | 2006-10-17 08:28:34 -0700 (Tue, 17 Oct 2006) | 7 lines
Uwe, I added some print statements to relevant parts of dBackend's
getStructureDescription(). This will sort out which chunk of that
function is mis-generating the SQL. Please update to HEAD, run your
app, and then post the output.
Thanks
------------------------------------------------------------------------
r2366 | paul | 2006-10-18 19:32:42 -0700 (Wed, 18 Oct 2006) | 3 lines
Removed the debugging output from dBackend, as it was affecting performance.
------------------------------------------------------------------------
He's getting partially-generated SQL which is raising a query error. Here's his
traceback:
[EMAIL PROTECTED]:~/mysrc/ugfw/fwadm> python fwadm.py
Dabo Info Log: Tue Oct 17 16:57:35 2006: 1 database connection
definition(s) loaded.
Dabo Info Log: Tue Oct 17 16:57:36 2006: User interface set to 'wx' by dApp.
Dabo Info Log: Tue Oct 17 16:57:36 2006: wxPython Version: 2.6.2.1 wxGTK
(unicode) (gtk2)
BACKEND <dabo.db.dbFirebird.Firebird object at 0xb79d1a2c>
Traceback (most recent call last):
File "/home/uwe/src/dabo/dabo/lib/eventMixin.py", line 97, in raiseEvent
bindingFunction(event)
File "", line 137, in onHit
File "/tmp/tmpBRzOia.py", line 8, in onHit_0
frm = dabo.ui.createForm(frmclass)
File "/home/uwe/src/dabo/dabo/ui/uiwx/__init__.py", line 822, in
createForm
frm = cls()
File "", line 14, in __init__
File "/home/uwe/src/dabo/dabo/ui/uiwx/dForm.py", line 762, in __init__
BaseForm.__init__(self, preClass, parent, properties, *args, **kwargs)
File "/home/uwe/src/dabo/dabo/ui/uiwx/dForm.py", line 39, in __init__
fm.dFormMixin.__init__(self, preClass, parent, properties, *args,
**kwargs)
File "/home/uwe/src/dabo/dabo/ui/uiwx/dFormMixin.py", line 62, in __init__
attProperties, *args, **kwargs)
File "/home/uwe/src/dabo/dabo/ui/uiwx/dPemMixin.py", line 175, in __init__
self._afterInit()
File "/home/uwe/src/dabo/dabo/ui/uiwx/dForm.py", line 65, in _afterInit
super(BaseForm, self)._afterInit()
File "/home/uwe/src/dabo/dabo/ui/uiwx/dFormMixin.py", line 100, in
_afterInit
super(dFormMixin, self)._afterInit()
File "/home/uwe/src/dabo/dabo/ui/uiwx/dPemMixin.py", line 250, in
_afterInit
self.afterInit()
File "", line 178, in afterInit
File "/tmp/tmpQsoG3Q.py", line 86, in afterInit_6
biz.DataSource = "etyp"
File "/home/uwe/src/dabo/dabo/biz/dBizobj.py", line 138, in __setattr__
isFld = self.setFieldVal(att, val)
File "/home/uwe/src/dabo/dabo/biz/dBizobj.py", line 1117, in setFieldVal
if fld in [f[0] for f in self.DataStructure]:
File "/home/uwe/src/dabo/dabo/biz/dBizobj.py", line 1383, in
_getDataStructure
return self._CurrentCursor.DataStructure
File "/home/uwe/src/dabo/dabo/db/dCursorMixin.py", line 1813, in
_getDataStructure
ds = self.BackendObject.getStructureDescription(self)
File "/home/uwe/src/dabo/dabo/db/dBackend.py", line 412, in
getStructureDescription
auxCrs.execute(tmpsql)
File "/home/uwe/src/dabo/dabo/db/dCursorMixin.py", line 225, in execute
raise dException.DBQueryException(e, sql)
DBQueryException: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n SQL
error code = -104\n Unexpected end of command')
SQL: SELECT
first 1
*
from
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
