Inscrit le: 09 Avr 2018
|Posté le: Mer 2 Mai - 15:59 (2018) Sujet du message: Order by fails
I have DBExpress Driver for SQ Server 5.0.3 with Delphi XE2 and a MS SQL 2008 server. I use TSimpleDataSet. In the dataset I use the query select * from tablename. The table is opened I see the results and I can sort all the comlumns by changing the query and refreshing the TSimpledataSet. If I opeen the tabel with "select * from tablename order by afiledname", I also get the table correct. But if I then want to change the sorting order by changing the query and refreshing the TSimpleDataSet, the table is not ordered any more. It sticks to the original sorting order.
What am I doing wrong?
Any help will be apprecited.
I didn't find the right solution from the Internet.
Promotional Marketing Example