| [Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] |
Append server-side filter to SQL statement
Source position: sqldb.pp line 671
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.
|
Should server-side filter be applied |