ClientDataSet order not working

Question

I have a problem with TClientDataSet . In a DataSet , the order by clause of my SQL works fine, but when I use TClientDataSet , the records are displayed in the order of the id database field.

What am I doing wrong?

Answer 1

Your problem is the TDataSetProvider , not the TClientDataSet .

Try setting the flag poRetainServerOrder to True in the TDataSetProvider.Options property:

Informs that the client should not try to restore the default order by sorting the records in the data packet. This does not allow the client to change the recording order , because, for example, he cannot duplicate the locale on the server.