Ed Leafe wrote:
On Feb 23, 2006, at 5:12 AM, sk2001de wrote:
I'm a bit puzzled how to sort the data retrieved by the query
(datanav.Form derived class). With the FieldSpecEditor resp. in the
according file fieldSpecs.fsxml I can determine the order in which the
fields appear in the forms. In the method BizXXX.setBaseSQL() (BiyXXX
derived from dBizObj) I can use self.addOrderBy() or
self.setOrderByClause() but this seems to be overridden before the
query is made.
A while ago I added a hack to order the columns, and since we never
figured out a better way, it's still in there. Right-click on the
*label* for the column on the select page, and you'll get a context menu
that will allow you to sort on that column.
I could rely on the user to click a column header in order to sort the
data, but in conjunction with the LIMIT clause sorting is necessary to
get usable datasets.
Paul may come up with a better solution, since he refactored the
datanav stuff into its current form, but the right-click on the label
should work.
We need to add another "page" that lets the user specify the order. And,
we need to add a way for users to save select/order defaults, so they
don't have to manually set it up each time.
More importantly, we need to figure out why manually setting the order
by clause is getting overwritten by the framework though...
--
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
