Are you working with FireDAC in Delphi or windows ide? FireDAC is a unique set of Universal Data Access Components for developing multi-device database applications for Delphi. It provides methods to sort, filter, or locate a specific record in the dataset. To sort the dataset by field values, the application uses the IndexFieldNames property. It supports multiple fields, case-insensitive, and descending modes.
However, if you want to sort in reverse order, you might consider watching this Learn Delphi video tutorial provided by Alister Christie. In this video, Alister will show you how you can use the IndexFieldNames property on any FireDAC TDataSet to enable sorting when clicking on a TDBGrid Title. Watch his step-by-step demonstration above and see how you can utilize this property.