TADDataSet.ApplyRange Method

Applies a range to the dataset.

Group

Links

TADDataSet Class, TADDataSet Members, uADCompDataSet Namespace, Example, public, See Also

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.

Syntax

procedure ApplyRange;

Example

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

What do you think about this topic? Send feedback!