I agree with the suggestions here. You have 2 easy ways to do it:

1. Directly on the DataObject of your DDDW at design time (DW Designer).
2. During runtime. In this case you would need to get the DWChild and Sort it with the SetSort() and Sort() methods.

It mostly depends on your needs. If your app needs to be dynamic, then the option 2 would be your candidate. Now, just consider that these two are not the only options you have. But maybe getting in to too much detail could make this post bulky. Unless, of course, you actually require something more elaborate. 

Regards,

If the DataWindow object has a sort order in the SQL or has DataWindow sorting set, it should appear in that order.

You should make note that the DropDownDataWindow is only retrieved once and therefore is the same for every row. If you attempt to sort it in code using GetChild as suggested, it will only work if there is one order.

Throw the current DDDW object out and start over.

Use the DW Painter to create your DDDW.
Use the ROWS/SORT option to specify your desired sort order.
Save.
Exit the painter and regenerate.
Get back into the painter and  test.

Sometimes the only way to fix it is to toss it and just start over.


Good Luck,

Olan

If you specified the sort order in the datawindow object that you use as DDDW the data should be ordered after retrieve.

If you want to set the sort order at runtime you can do it with the datawindow child:

DataWindowChild ldwc_dddw

IF GetChild ("your_dddw_column", ldwc_dddw) = 1 THEN

   ldwc_dddw.SetSort ("your sort definition")

   ldwc_dddw.Sort ()

END IF