Zeoslib Portal

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

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

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

And how to sord descendant or inverse the sort order?

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

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.

Use the SortedFields property...

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