Hi,
In the past I was able to use a temp table doing the following:
csql = 'a long create temp table statement with the name tempstudent'
biz = dabo.biz.dBizobj(connection)
biz.execute(csql)
biz.DataSource = 'temptstudent' #the temp table name
biz.KeyField = "pkid"
biz.new()
What is the correct to use a temp table (a temp table must be used
within the same session)?
But now I get the following traceback.
Traceback (most recent call last):
File "esfastentry.py", line 5296, in <module>
app.start()
File "/home/johnf/dabo/dabo/dApp.py", line 388, in start
self.setup()
File "/home/johnf/dabo/dabo/dApp.py", line 340, in setup
self.initUIApp()
File "/home/johnf/dabo/dabo/dApp.py", line 380, in initUIApp
self.uiApp.setup()
File "/home/johnf/dabo/dabo/ui/uiwx/uiApp.py", line 432, in setup
frm = self.dApp.MainForm = mfc()
File "/home/johnf/dabo/dabo/ui/uiwx/dForm.py", line 1043, in __init__
*args, **kwargs)
File "/home/johnf/dabo/dabo/ui/uiwx/dForm.py", line 40, in __init__
attProperties=attProperties, *args, **kwargs)
File "/home/johnf/dabo/dabo/ui/uiwx/dFormMixin.py", line 76, in __init__
attProperties=attProperties, *args, **kwargs)
File "/home/johnf/dabo/dabo/ui/uiwx/dPemMixin.py", line 202, in __init__
self._afterInit()
File "/home/johnf/dabo/dabo/ui/uiwx/dForm.py", line 58, in _afterInit
super(BaseForm, self)._afterInit()
File "/home/johnf/dabo/dabo/ui/uiwx/dFormMixin.py", line 124, in
_afterInit
self.createBizobjs()
File "esfastentry.py", line 3318, in createBizobjs
self.tempStudentBiz = self.createTempStudentTable(self.tempconn)
File "esfastentry.py", line 4820, in createTempStudentTable
biz.new()
File "/home/johnf/dabo/dabo/biz/dBizobj.py", line 1168, in new
self._CurrentCursor.new()
File "/home/johnf/dabo/dabo/db/dCursorMixin.py", line 1832, in new
blank = self._getBlankRecord()
File "/home/johnf/dabo/dabo/db/dCursorMixin.py", line 1826, in
_getBlankRecord
self.__setStructure()
File "/home/johnf/dabo/dabo/db/dCursorMixin.py", line 2042, in
__setStructure
self.__setNonUpdateFields()
File "/home/johnf/dabo/dabo/db/dCursorMixin.py", line 759, in
__setNonUpdateFields
self.__nonUpdateFields = self.BackendObject.setNonUpdateFields(self)
File "/home/johnf/dabo/dabo/db/dBackend.py", line 496, in
setNonUpdateFields
auxCrs.execute(auxCrs.getSQL())
File "/home/johnf/dabo/dabo/db/dCursorMixin.py", line 389, in execute
raise dException.DBQueryException(errMsg)
dabo.dException.DBQueryException: relation "tempstudent" does not exist
LINE 2: from tempstudent
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
