Implements a virtual method for searching a dataset for a specified record and making it the active record.function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; virtual;DescriptionThis function Checks whether the dataset is unidirectional, and if so, raises an EDatabaseError exception. Returns False, indicating that a matching record was not found and the active record was not changed.Descendant classes that are not unidirectional override this method so that it locates the record where the fields identified by the semicolon-separated list of fields in 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 that record is now active.
locate('name',('AAA'),[])
Returns False, indicating that a matching record was not found and the active record was not changed.Descendant classes that are not unidirectional override this method so that it locates the record where the fields identified by the semicolon-separated list of fields in 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 that record is now active.
1、单个字段：
table1.locate('FieldName','SearchText',[loCaseInsensitive, loPartialKey]);
2、多个字段
table1.locate('Field1;Field2;Field3','Text1;Text2;Text3',[loCaseInsensitive, loPartialKey]);