reversing the records
Posted: Mon 02 Aug 2010 14:24
This reversing the records at the time of recording in the database. Example:
Release:
1
2
3
4
Recorded:
4
3
2
1
Release:
1
2
3
4
Recorded:
4
3
2
1
Hello
Please specify the database that you are using. Also please specify which DAC components you are using (ODAC, IBDAC, UniDAC, etc.).
Please describe what does it mean: "reversing the records". Records in a database don't have any order. You can insert records in the order:
1
2
3
4
And a database can return you the following order:
1
3
4
2
It is correct.
If you want to get some special order then you should use the ORDER BY statement in your SQL query:
select *
from MyTable
order by Name