On Feb 1, 2010, at 6:38 AM, Jacek Kałucki wrote:
>> Are you saying that you ran two queries against the same columns, and
>> got different data types back from the same column on each query? I've never
>> seen this happen. If the first time a column is queried it returns a certain
>> data type, I would expect it to always return the same data type.
>
> As a test it's enough to execute:
> sql = "select * from any_table"
> cursor.execute(sql, _newQuery=True)
> cursor.execute(sql, _newQuery=False)
Oh, now I understand. You're not using the framework; instead, you're
taking internal implementation details and expecting them to work out of
context.
Try something like this instead: run a typical form, and before any
queries are run, open a command window and type:
>>> b = self.PrimaryBizobj
>>> b.setFieldClause("*")
>>> b.setLimit(100)
>>> b.setOrderByClause("iid")
>>> b.requery()
>>> d1 = b.getDataSet()
>>> b.requery()
>>> d2 = b.getDataSet()
>>> print d1 == d2
True
If you get differences using the framework as it was designed to be
used, please let me know.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]