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
TIBQuery and Sort
Re: TIBQuery and Sort
Yes, there is such a capability in IBDAC. Set the needed value for the IndexFieldNames property of the TIBCQuery component, for example:
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
Code: Select all
IBCQuery1.IndexFieldNames := 'field1';
See more details in our documentation:
http://www.devart.com/ibdac/docs/index. ... dnames.htm
Re: TIBQuery and Sort
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
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
Re: TIBQuery and Sort
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
Don't worry
I have found the solution
![Smile :)](./images/smilies/icon_smile.gif)
DataSet1.IndexFieldNames := 'LastName ASC CIS; DateDue DESC';
http://www.devart.com/ibdac/docs/index. ... tions).htm
Re: TIBQuery and Sort
It is good to see that the problem has been solved.
If any other questions come up, please contact us.
If any other questions come up, please contact us.