TTdbDataSet.Locate
TTdbDataSet

Searches a specified record and makes that record the active record.

function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean;

Description
Searches for a record in the dataset, where the fields identified by the comma-delimited string KeyFields have the values specified by the Variant or Variant array KeyValues. Options indicates whether the search is case insensitive and whether partial matches are supported. Locate returns True if a record is found that matches the specified criteria and the cursor repositioned to that record.