ORDER BY DESC

[jasmad]

Hi,
I want to sort a ibctable by id descending
there is any way to do that with this component?

Regards.

[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'