Question:
I have a datawindow where I sort the data by clicking on the column header. In one of the columns I have a drop-down datawindow attached. Whenever I click this column, the data gets sorted according to the data value. But what I need is to sort the data according to the display value of that column. Is it possible to achieve this?
Answer:
Unfortunately, PowerBuilder does not support this feature natively. The only way to achieve this would be to add a special section to your code.
In the function that processes the clicked event, check the type of the column being clicked. If it is a drop-down datawindow, you could call a function that performs a sort on the contents of the datawindow child.
To do this, use GetChild to get a handle to the datawindow child and look up the display value for each data value. Then write your own simple bubble sort routine.