RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TCustomADODataSet.Lookup Method
TCustomADODataSet Class | TCustomADODataSet Members | ADODB Namespace | Description | See Also
Collapse All

Retrieves field values from a row that matches specified search values.

Pascal
function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant; override;
C++
virtual __fastcall Variant Lookup(const AnsiString KeyFields, const Variant KeyValues, const AnsiString ResultFields);
Description

Call Lookup to retrieve values for specified fields from a row that matches search criteria. KeyFields is a string containing a semicolon-delimited list of field names on which to search. 

KeyValues is a variant array containing the values to match in the key fields. To specify multiple search values, pass KeyValues as a variant array as an argument, or construct a variant array on the fly using the VarArrayOf routine. 

ResultFields is a string containing a semicolon-delimited list of field names whose values should be returned from the matching row. 

Lookup returns a variant array containing the values from the fields specified in ResultFields. 

 

See Also

ADONETDb.TCustomADONETConnector.Locate

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!