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


Filter to apply to the data in memory.


Source position: db.pas line 1736

public property TDataSet.Filter : string
  read FFilterText
  write SetFilterText;


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.

See also



Is the filter active or not.



Options to apply when filtering

Documentation generated on: Jun 22 2020