TSQLQuery.ServerFilter property

Declaration

property ServerFilter:;

Description

ServerFilter can be set to a valid WHERE clause (without the WHERE keyword). It will be appended to the select statement in SQL, when ServerFiltered is set to True. if ServerFiltered is set to False, ServerFilter is ignored.

If the dataset is active and ServerFiltered is set to true, then changing this property will re-fetch the data from the server.

This property cannot be used when ParseSQL is False, because the statement must be parsed in order to know where the WHERE clause must be inserted: the TSQLQuery class will intelligently insert the clause in an SQL select statement.

Errors

Setting this property when ParseSQL is False will result in an exception.

See also

• ServerFiltered