[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] Reference for unit 'SQLDB' (#fcl)


Append server-side filter to SQL statement


Source position: sqldb.pp line 681

published property TSQLQuery.ServerFilter : string;


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.


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

See also



Should server-side filter be applied

Documentation generated on: Jun 22 2020