Difference between tuniquery.filter and tuniquery.filterSQL

[jota]

Hello.

What´s the difference between properties tuniquery.filter and tuniquery.filterSQL.

Perhaps tuniquery.filter accept functions for data filter (not only sql code)? In this case is a little sample possible?.

Thank in advance.

[AndreyZ]

Hello,

The Filter property is used for local filtering of a dataset and the FilterSQL property for filtering on the server side. FilterSQL adds conditions to the WHERE statement of your queries, therefore you can use any conditions in it that are supported by the database server you are working with. For more information about the FilterSQL property, please refer to the UniDAC documentation.