On 5/1/13 4:16 PM, John Fabiani wrote: > 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)?
This looks right. But you have: biz.DataSource = 'temptstudent' and then: > 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 So it looks to me like you jumped to the conclusion your typo was Dabo's fault. ;) Paul _______________________________________________ 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]
