sortingdelphiindexingnulltclientdataset

Delphi: Sort ClientDataSet by datetime asc, nulls last

I need to sort a ClientDataSet by a DateTime field, e.g. next_due_date, in ascending order and with null values last.

I will be adding new records at runtime and I am not allowed to execute the SQL query again.

Can you use an index on a ClientDataSet in such a way?

Solution

  • you could create internal calculated field in cds, populate it as your needs dictate and create an index referring to that field