Datasnap.DBClient.TCustomClientDataSet.GotoNearest

• Up to Parent: TCustomClientDataSet

Delphi

procedure GotoNearest;

C++

void __fastcall GotoNearest();

Properties

Type	Visibility	Source	Unit	Parent
procedure function	public	Datasnap.DBClient.pas Datasnap.DBClient.hpp	Datasnap.DBClient	TCustomClientDataSet

Description

Moves the cursor to the record that most closely matches the current key.

Call GotoNearest to position the cursor on the record that is either the exact record specified by the current key values in the key buffer, or on the first record whose values exceed those specified. If there is no record that matches or exceeds the specified criteria, GotoNearest positions the cursor on the last record in the dataset.

Note: KeyExclusive determines which records are considered part of a search range.

Before calling GotoNearest, an application must specify key values by calling SetKey or EditKey to put the dataset in dsSetKey state, and then use FieldByName to populate the buffer with search values.

See Also

• FindNearest

• GotoKey

• KeyExclusive

• SetKey

• Data.DB.TDataSet.State

• Data.DB.TDataSet.FieldByName

• Executing a Search with Goto Methods