From RAD Studio API Documentation
Jump to: navigation, search


property Filtered: Boolean read FFiltered write SetFiltered default 0;


__property Filtered = {default=0};


Type Visibility Source Unit Parent
property published
FireDAC.Comp.Client TFDQuery


Specifies whether or not filtering is active for a dataset.

FireDAC.Comp.Client.TFDQuery.Filtered inherits from Data.DB.TDataSet.Filtered. All content below this line refers to Data.DB.TDataSet.Filtered.

Specifies whether or not filtering is active for a dataset.

Check Filtered to determine whether or not dataset filtering is in effect. If Filtered is true, then filtering is active. To apply filter conditions specified in the Filter property or the OnFilterRecord event handler, set Filtered to true. Because unidirectional datasets do not support filters, when you set Filtered to true on a unidirectional dataset, it raises an exception.

Note: When filtering is enabled, user edits to a record may mean that the record no longer meets a filter's test condition. The next time an attempt is made to the read the record from the dataset while the filter is in effect, the record is not visible. If that happens, the next record that passes the filter condition becomes the active record.

See Also