Page 1 of 1

ORDER BY DESC

Posted: Wed 02 May 2012 22:15
by jasmad
Hi,
I want to sort a ibctable by id descending
there is any way to do that with this component?

Regards.

Re: ORDER BY DESC

Posted: Thu 03 May 2012 09:53
by ZEuS
Hello.

To sort a table by id descending you can use either local sorting or server-side sorting.
To perform local sorting you should set

Code: Select all

IBCTable.IndexFieldNames := 'ID DESC'
You can find more detailed information about local sorting in the "TMemDataSet.IndexFieldNames Property" article of the IBDAC documentation.

To perform server-side sorting you should set

Code: Select all

IBCTable.OrderFields := 'ID DESC'