FireDAC.Comp.DataSet.TFDDataSet.GotoNearest

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

procedure GotoNearest;

C++

void __fastcall GotoNearest();

Properties

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

Description

Searches for a closest record, using values in the key buffer.

Use GotoNearest to search for a record, using values assigned to the indexed fields, after a previous call to SetKey/EditKey

Before the call, the dataset must be in dsSetKey state. If GotoNearest finds a record, it makes it the current record in the dataset. Otherwise, the first record with greater values than the specified values become the current record in the dataset.

Example

FDQuery1.IndexFieldNames := 'CUSTOMER_ID;ORDER_DATE';
FDQuery1.SetKey;
FDQuery1.FieldByName('CUSTOMER_ID').AsInteger := 100;
FDQuery1.FieldByName('ORDER_DATE').AsDateTime := EncodeDate(2008, 5, 1);
FDQuery1.GotoNearest;

See Also