Hi All,
Dim Dtatable As SAPbouiCOM.DataTable
tGrid = tForm.Items.Item("1").Specific
Dtatable = tForm.DataSources.DataTables.Add("dtTemp")
Dtatable = tForm.DataSources.DataTables.Item("dtTemp")
strQuery = "Select * from EMP order by Hire Date desc" <---------
tGrid.DataTable = Dtatable
tGrid.DataTable.ExecuteQuery(strQuery)
tGrid.CollapseLevel = 1
tGrid.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto
In the above code iam showing the employee data based on hire date in a new history window,now my problem is iam unable to show the employee data based on hire date on DESCENDING ORDER as ascending order is getting worked up properly but for DESC the data is getting displayed as ascending only.can anybody suggest me some ideas to solve this problem.
thanks
dileep varma s