reversing the records

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
felipeiw
Posts: 10
Joined: Mon 29 Mar 2010 16:26

reversing the records

Post by felipeiw » 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

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Tue 03 Aug 2010 10:59

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

Post Reply