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.
-- Ed Leafe -- http://leafe.com -- http://dabodev.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
