reversing the records

reversing the records

Postby 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
felipeiw
 
Posts: 10
Joined: Mon 29 Mar 2010 16:26

Postby 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
bork
Devart Team
 
Posts: 643
Joined: Fri 12 Mar 2010 07:55


Return to dbExpress driver for PostgreSQL