I have a TADODataSet that loads some columns from the DB (a SP, but that does not matter). e.g:
SELECT A, B, C, D FROM Foo
Now, after I open the dataset, Is it possible to change the order of fields (or swap them) in that TADODataSet so that it will contain e.g:
C, D, A, B
I want to do it without changing the command text itself. Is it possible?