FireDAC.Comp.DataSet.TFDDataSet.ApplyRange

• Up to Parent: TFDDataSet

Delphi

procedure ApplyRange;

C++

void __fastcall ApplyRange();

Properties

Type	Visibility	Source	Unit	Parent
procedure function	public	FireDAC.Comp.DataSet.pas FireDAC.Comp.DataSet.hpp	FireDAC.Comp.DataSet	TFDDataSet

Description

Applies a range to the dataset.

Use ApplyRange to actually filter dataset records using range values specified with SetRangeStart and SetRangeEnd, or EditRangeStart and EditRangeEnd method calls. When a range is in effect, only those records that fall within the range are available to the application for navigating, viewing, and editing. After a call to ApplyRange, the cursor is left on the first record in the range.

Example

FDQuery1.IndexFieldNames := 'CUST_NO';
FDQuery1.SetRangeStart;
FDQuery1['CUST_NO'] := '100';
FDQuery1.SetRangeEnd;
FDQuery1['CUST_NO'] := '200';
FDQuery1.ApplyRange;

See Also

• Filtering Records
• FireDAC.Comp.DataSet.TFDDataSet.CancelRange
• FireDAC.Comp.DataSet.TFDDataSet.EditRangeEnd
• FireDAC.Comp.DataSet.TFDDataSet.EditRangeStart
• FireDAC.Comp.DataSet.TFDDataSet.SetRange
• FireDAC.Comp.DataSet.TFDDataSet.SetRangeEnd
• FireDAC.Comp.DataSet.TFDDataSet.SetRangeStart
• FireDAC.Comp.DataSet.TFDDataSet.IsRanged