lookup
From Free Pascal wiki
Jump to navigationJump to searchThe printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
│
English (en) │
français (fr) │
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.