TIBQuery and Sort

[alexhaifa]

Hello,

I'd like to know if it is possible after opening a query sort it by field without close and
open it again. Like Adoquery allows with Adoquery.sort := 'field asc';

thanks
Alexandre

[PavloP]

Yes, there is such a capability in IBDAC. Set the needed value for the IndexFieldNames property of the TIBCQuery component, for example:

Code: Select all

IBCQuery1.IndexFieldNames := 'field1';

This will lead to records sorting in the dataset without closing it.
See more details in our documentation:
http://www.devart.com/ibdac/docs/index. ... dnames.htm

[alexhaifa]

Hello PavloP,

Thanks for your reply. But I am having some problem with this.
My language is portuguese and I have some accented words, when I make a query

I order the query this way:

ORDER BY FIELD ASC COLLATE PT_PT

The collate avoid obey accented word and give a correct order, when I tried your tip,
it worked without any collate possibility. I really need the collate PT_PT to avoid ordering the query abeying accented words. Is there any way to do this?

Thanks
Alexandre

[alexhaifa]

Hello,

Don't worry

I have found the solution )

DataSet1.IndexFieldNames := 'LastName ASC CIS; DateDue DESC';

http://www.devart.com/ibdac/docs/index. ... tions).htm

[PavloP]

It is good to see that the problem has been solved.
If any other questions come up, please contact us.