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

TDataSet.Filter

Filter to apply to the data in memory.

Declaration

Source position: db.pas line 1354

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

Description

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

TDataset.Filtered

  

Is the filter active or not.

TDataset.FilterOptions

  

Options to apply when filtering

The latest version of this document can be found at lazarus-ccr.sourceforge.net.