Hi,
i set the SQL Statement in the IBQuery dynamically by calling
IBQuery.SQL.text := yourcurrentquery + ' ORDER BY ' +
var_yourfieldtoorder;
Simon

-----Ursprungliche Nachricht-----
Von: StinkyDuck [mailto:shaq@...]
Gesendet: Dienstag, 15. April 2003 10:35
An: IBObjects@yahoogroups.com
Betreff: [IBO] TIBOQuery Sorting


I am using TIBOQuery and retrieving records. Can I dynamically sort the
records I have without having to perform another query?

Say for example I query for IDNumber, FirstName, and LastName. For one
function I would need to sort my query by IDNumber. For another function I
would need to sort by LastName.

Is this possible without having to perform another query on the database?

Any help would be greatly appreciated.

Thanks.



Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.