On 05/01/2013 04:43 PM, Paul McNett wrote:
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
No actually that was a typo I made in the email and not actual code.
I discovered that I was able to do an insert and commit using the 'biz'
but still can set the DataSource using the above.
Looks like I'll have check further into the code to discover why.
Johnf
Johnf
_______________________________________________
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]
