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.