Sort a Delphi dataset

delphi delphi-xe2 devart
LaBracca picture LaBracca · Jan 8, 2013 · Viewed 9.9k times · Source

I have an unsorted dataset (a TMSQuery from Devart) that I cannot sort using ORDER BY because I manipulate the records after opening the query so the order given by "ORDER BY" is lost.

I don't want to rewrite the whole logic so I should find a way to sort a dataset.

I can Assign the dataset to a TMemDataSet (TMemDataSet is a DevArt class) descendant (TVirtualTable from Devart), but after this how do I sort (I need to sort by a date field)?

I read this question but it doesn't relly contain the answer I am looking for.

Answer

LaBracca picture LaBracca · Jan 8, 2013

Using IndexFieldNames I solved the problem, it was what I waslooking for. Directly from the TMSQuery component:

MSQuery1.IndexFieldNames := 'EXECUTION_DATE'; //this does the job

Related questions

Why does CreateProcess give error 193 (%1 is not a valid Win32 app)

The code below fails to start documents. I get error 193 (%1 is not a valid Win32 app). Starting executables work fine. The files are properly associated, they start the corresponding app when double clicked. I have searched SO and elsewhere for …

Read More
Using Case Statement with String

Say i have a string 'SomeName' and wanted the values return in a case statement. Can this bedone? Can strings be used in a case statement like so Case 'SomeName' of 'bobby' : 2; 'tommy' :19; 'somename' :4000; else showmessage('Error'); end;

Read More
Delphi VCL styles tutorial - how to change the style at runtime

Is there a good VCL Styles tutorial where we see how to dynamically (in run time) load/change the style ? This should work with Delphi XE2 and up, since XE2 is the first version with VCL Styles.

Read More