On Tuesday 07 November 2006 08:48, johnf wrote: > Hi, > > So what did I miss? > > I'm able to use CxnEditor.py works (makes a connection). AppWizard.py can > connect and sees the tables. But when I do the requery the app (called > dean2.py) produced from AppWizard.py produces the following : > Dabo Info Log: Tue Nov 7 08:43:04 2006: 1 database connection > definition(s) loaded. > Dabo Info Log: Tue Nov 7 08:43:04 2006: User interface already set to > 'wx', so dApp didn't touch it. > Dabo Info Log: Tue Nov 7 08:43:04 2006: wxPython Version: 2.6.1.0 wxGTK > (unicode) (gtk2) > Traceback (most recent call last): > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/lib/eventMixin.p >y", line 97, in raiseEvent > bindingFunction(event) > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/lib/datanav/Page >.py", line 332, in onRequery > self.requery() > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/lib/datanav/Page >.py", line 358, in requery > ret = frm.requery() > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/lib/datanav/Form >.py", line 111, in requery > return self.super(dataSource) > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/lib/autosuper/au >tosuper.py", line 175, in __call__ > return method(*p, **kw) > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/ui/uiwx/dForm.py >", line 345, in requery > response = dProgressDialog.displayAfterWait(self, 2, bizobj.requery) > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/ui/uiwx/dProgres >sDialog.py", line 118, in displayAfterWait > tm = dProgressTimer(parentWindow, func, seconds) > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/ui/uiwx/dProgres >sDialog.py", line 94, in __init__ > func() > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/biz/dBizobj.py", > line 644, in requery > cursor.rollbackTransaction() > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/db/dCursorMixin. >py", line 1540, in rollbackTransaction > ret = self.BackendObject.rollbackTransaction(self.AuxCursor) > File > "/usr/lib/python2.4/site-packages/Dabo-0.7a-py2.4.egg/dabo/db/dBackend.py", > line 212, in rollbackTransaction > cursor.connection.rollback() > AttributeError: 'cursorMix' object has no attribute 'connection'
I just realized that I'm sending an illegal sql statement - "LIMIT" is not part of T-SQL. I see if I can fix that? johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
