Hi,
Dabo2, Phoenix (at least I think so) Python 2.7.
I've come across an interesting issue when creating a temp table on the
database side.
I use Dabo's connection to create a bizobj. Then use the bizobj.execute
to issue a DDL to create the temp table in the database. The three
databases I use allow this without issue. I use to set the following
and it worked just fine in Dabo 0.9:
bizobj.UserSQL = "select * from temptable"
bizobj.requery()
At this point there is no data in the table. And a grid can use it as a
dataset.
With Dabo2 and Phoenix an error happens when I try to assign the empty
table for the grid's dataset. The error occurs because when the grid
attempts to use the dataset the 'val' is None. I'm sure you are asking
where's the traceback? But I not concerned with the error. What got my
attention was the fact (by accident BTW) I discovered a work around.
def function(self)
csql = "select * from temptable"
bizobj.execute(csql)
return bizobj.getDataSet()
Now the grid just works - produces no errors of any sort. I can add to
my temp table etc..
Following the code - requery does exactly the same thing. It sets the
SQL, executes the SQL, and attempts to get the dataset. Very strange -
I've done something in the grid routine that is an edge case bug.
So this is just an heads up email. I actually don't know where the bug
is in grid.py and I tried to find the issue.
Johnf
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[email protected]
