Difference between revisions of "lookup"
From Lazarus wiki
Jump to navigationJump to search (Created page with "{{Translate}} == Definition == Unit: FreePascal, unit '''db''' <syntaxhighlight> function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: s...") |
m (→Description) |
||
| Line 11: | Line 11: | ||
== Description == | == Description == | ||
| − | '''lookup''' is similar to '''locate'' in that it looks for a record in the dataset where the specified search values for the specified fields match. | + | |
| + | '''lookup''' is similar to '''locate''' in that it looks for a record in the dataset where the specified search values for the specified fields match. | ||
If found, the function returns a variant array with the values of the ResultFields (a semicolon-delimited list of desired fields). | If found, the function returns a variant array with the values of the ResultFields (a semicolon-delimited list of desired fields). | ||
| Line 22: | Line 23: | ||
{{Note|Lookup is only implemented in non-unidirectional datasets, i.e. you must be able to move back and forwards through the dataset.}} | {{Note|Lookup is only implemented in non-unidirectional datasets, i.e. you must be able to move back and forwards through the dataset.}} | ||
| − | |||
== See also == | == See also == | ||
Revision as of 19:42, 14 December 2012
Definition
Unit: FreePascal, unit db
function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant;Official documentation: none
Description
lookup is similar to locate in that it looks for a record in the dataset where the specified search values for the specified fields match.
If found, the function returns a variant array with the values of the ResultFields (a semicolon-delimited list of desired fields). If not found, it returns Null. In neither case does it change the current physical record/cursor.
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.
Note: Lookup 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 lookup with Delphi
