TSQLQuery.ServerFilter¶
Append server-side filter to SQL statement.
Declaration¶
Source position: sqldb.pp line 753
published 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.
See also¶
| Name | Description |
|---|---|
| ServerFiltered | Should server-side filter be applied. |