sorting Descending with IBQuery ?

[abak]

Hi,
How can i create an index Descending in IBQuery, for sorting data :
(not in the query sql)
Exemple :this gives Ascending sort:

ibQuery.indexFieldName:='myField';
Thx.

[ViktorV]

Please try using the following code to apply descending sorting:

Code: Select all

IBQuery.IndexFieldNames := 'myField DESC';

You can find more details in the IBDAC help: http://www.devart.com/ibdac/docs/index. ... dnames.htm

[abak]

Thank you ViktoV.
So easy !

[ViktorV]

Thank you for your interest to our product. Feel free to contact us if you have any further questions.