TCustomSQLQuery.Filter property

Declaration

property Filter:;

Description

Not described here; this is what TDataSet.Filter says of it:

Filter to apply to the data in memory.

Filter is not implemented by TDataset. It is up to descendent classes to implement actual filtering: the filtering happens on in-memory data, and is not applied on the database level. (in particular: setting the filter property will in no way influence the WHERE clause of an SQL-based dataset).

In general, the filter property accepts a SQL-like syntax usually encountered in the WHERE clause of an SQL SELECT statement.

The filter is only applied if the Filtered property is set to True. If the Filtered property is False, the Filter property is ignored.