how to sort data in ZTable ?

OverseasHost.com · Post by **OverseasHost.com** » 26.01.2006, 08:19

hi all

how to sort data in ZTable ?

i opened a ZTable , and set IndexFieldNames to the primary key

when i preview in dbgrid , and insert some value and insert the primary key not in order ( for ex. 4 value after 2 ) it is not reordered to the primary key

what could i do to make the ZTable Reorder automatically with the Primary Key

Thanx

zippo · Post by **zippo** » 26.01.2006, 11:09

I wish I knew.. Today I'm forced to do it via SQL... Developers, any ideas?

btrewern · Post by **btrewern** » 26.01.2006, 20:24

See SortedFields property.

Regards,

BTW TZTable components and their like are just plain bad! Best to use TZQuery and select only the fields you want.

Ben

zippo · Post by **zippo** » 05.03.2006, 10:25

And how to sord descendant or inverse the sort order?

silviogs · Post by **silviogs** » 05.03.2006, 13:47

Hi

use the component zquery it would be easier for you. In the property SQL types:

select * from your table
order by field asc (desc)

Respectfully

Silvio Guedes

zippo · Post by **zippo** » 05.03.2006, 15:57

I do use ZQuery, but I've done a simple routine to do the client-side sorting by clicking on the grit captions... I old Zeos there were two properties SortInverse and Sort.
In Zeos 6.x they are missing.

markd_mms · Post by **markd_mms** » 06.03.2006, 00:14

Use the SortedFields property...

e.g.
SortedFields = "1 ASC, 2 DESC";