Sort Datawindow on clicking the Datawindow Header in PowerBuilder
Published on 16 September 16
Venkatesh Guptha
0
// Create a Datawindow with header
// When we click on the datawindow header, the below code will sort the datawindow based on the header selection. If the datawindow is already sorted(suppose with col1 ascending) , the below code checks for it and sorts with col1 desc crieteria.
// Write the below code in the Datawindow Clicked event
string ls_columnheader,ls_columnName,ls_sortcriteria
ls_columnheader=dwo.name
ls_sortcriteria = this.Object.DataWindow.Table.Sort
if right(ls_columnheader,2)='_t' then // Column header contains _t
ls_columnName=left(ls_columnheader,(len(ls_columnheader)-2))
// while sorting we should not have the _t in the name
if right(ls_sortcriteria,2)=" D" then
this.setsort(ls_columnName+" A")
else
this.setsort(ls_columnName+" D")
end if
setpointer(hourglass!)
this.sort( )
This blog is listed under
Development & Implementations
and Data & Information Management
Community
Related Posts:
Post a Comment
