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.