Difference between revisions of "locate"
From Free Pascal wiki
Jump to navigationJump to search (Created page with "{{Translate}} Unit: FreePascal, unit '''db''' <syntaxhighlight> function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; ov...") |
(No difference)
|
Revision as of 19:37, 14 December 2012
Unit: FreePascal, unit db
function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean; override;
//TDBF
Official documentation: none
locate looks for a record in the dataset where the specified search values for the specified fields match. If found, the function returns true and the cursor position/current record moves to that record.
KeyFields can be a single field name or a semicolon-separated list of fields.
KeyValue can be a variant or a variant array and the number of items must match the number of fields specified in KeyFields.
Search options can be
- loCaseInsensitive: ignore upper case/lower case differences when searching
- loPartialKey: match partial finds (instead of the complete key)
Note: Locate is only implemented in non-unidirectional datasets, i.e. you must be able to move back and forwards through the dataset.
See also
- [1] Description of how to use locate with Delphi