Phenomenon
If you add an "Ascending" option to the SORT script, this option gets lost.
Scenario
Do a SORT() to a DataWindow like follows:
STRING ls_sort
ls_sort = "COLUMN_NAME A"
dw_dwcontrol.SetSort(ls_sort)
dw_dwcontrol.Sort()
ls_sort = dw_dwcontrol.Describe("DataWindow.Table.Sort")This will return ls_sort = "COLUMN_NAME" without the "A" for Ascending at the end.
Workaround
Use only lower case letters on the SORT condition. Like follows:
STRING ls_sort
ls_sort = "column_name a"
dw_dwcontrol.SetSort(ls_sort)
dw_dwcontrol.Sort()
ls_sort = dw_dwcontrol.Describe("DataWindow.Table.Sort")This should return ls_sort = "column_name a" without loosing the "A" for Ascending.
