SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder
Implements a virtual method for searching a dataset for a specified record and makes that record the record active one.
function Locate(const KeyFields: String; const KeyValues: Variant; Options: TLocateOptions): Boolean; virtual;
This function returns False, indicating that a matching record was not found and the cursor is not repositioned.
Descendant classes override this method so that it locates the record where the fields identified by the comma-delimited string KeyFields have the values specified by the Variant or Variant array KeyValues. Options indicate whether the search is case insensitive and whether partial matches are supported. Locate should return True if ther is found a record that matches the specified criteria and the cursor is repositioned to the first such record.