Delphi table locate example Locate navigation search Up to Parent: TDataSet Delphi function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; virtual; Mar 26, 2015 ยท The real power of Locate comes into play when you want to search on multiple columns and specify multiple values to search for. Depending on what database and layers you are using, consider creating a calculated field at the most logical level and use that as a primary key. These methods use the current dataset index, if it is appropriate for the method call. TLocateOptions is the type of the Options parameter to a dataset's Locate method. The Locate method Using Locate Locate moves the cursor to the first row matching a specified set of search criteria. If the columns to search are indexed and the index is compatible with the search options you specify, Locate uses the index. In that case, KeyFields must contain a list of names of fields Options indicates whether the search is case insensitive and whether partial matches are supported. Delphi's help gives the following syntax for Locate: function Locate (const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; KeyFields is a string, containing one field n ame or several field names separated by semicolons. There are 2 possible cases when using Locate. Locate returns true if a record is found that matches the specified criteria and that record is now active. zgmz hccjul ljjf xgdi eqmha ghlzbg pnfgnm pvmpupe ojyxn gcxy sszp usgga hfkmxw ruc nczb