How to change the order of fields in an already opened TADODataSet?

Viewed 842

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?

1 Answers
Related