arranging the record of dgrid in ascending and descending order.

[iamtheatorres2408]

 Good Day,
                  how can i arrange the content record of my dbgrid into ascending or descending order? thank you..Godbless

[madref]

You can do that in your sql-statement
You would probably have something like

Code: SQL  [Select][+][-]

1. SELECT * FROM SomeTable

Add for small to big

Code: SQL  [Select][+][-]

1. SELECT * FROM SomeTable ORDER BY A_Field ASC

or from big to small

Code: SQL  [Select][+][-]

1. SELECT * FROM SomeTable ORDER BY A_Field DESC

[hrayon]

Hi,
You can try this too:
http://wiki.freepascal.org/Grids_Reference_Page#Sorting_Columns_or_Rows

[Thaddy]

That doesn't make much sense for a db aware control....without a query that sorts. So the queries are the correct solution.

[madref]

That doesn't make much sense for a db aware control....without a query that sorts. So the queries are the correct solution.

I agree. If you do it with source code you have to do it every time you change something.
When you do it with your sql. You only have to do it once

[hrayon]

I use both approaches at the same time in a solution. This minimizes requests to the server. The data is already on the client side, you just need to rearrange it.

[Thaddy]

That doesn't make much sense for a db aware control....without a query that sorts. So the queries are the correct solution.

I agree. If you do it with source code you have to do it every time you change something.
When you do it with your sql. You only have to do it once

It is even worse: remember the database itself is likely unordered.
- you read some number of records
- you sort those like in a normal grid.. (A..z, right?)
- user assumes he has read all A's!!!
- Next we read another chunk of the database
- you sort those like in a normal grid.. (A..z, right? Again)
- Guess what? there are more things that start with A and that is EXACTLY what a simple user does not understand.
- <sorry, but such things make me <grumpy  >>

Stick to queries, even if you have a local copy use a TBufDataset in that case.