Hi All.
Well after my emails on the weekend, a Listview was not going to cut it 
unfortunitly because it took too long to load the data from the DB into 
the listview. Even with a dataaware one.

So I went back to using a DBGrid, and stumbled onto a site that said with 
ADO, which I could use, you can use the SORT property to define the wsort 
order of the data !

i.e. myADOTable.Sort:='Client_ID DESC'  or ASC

This is quite quick, and solved my problems !
Not sure if anyone else was aware of this, so I thought I would pass it 
on.
I was using the TMS DBGrid, but that has some serious issues. Took me 
nearly 2 months to get them to fix one problem, and now, if I have found, 
if you sort the data, it will do it, but then when you scroll the grid, 
the data is no longer sorted and is just a total MESS !

Good old DBGrid saved the day !

Jeremy

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

Reply via email to