RAD Studio VCL Reference
TDataSet.Lookup Method

Implements a virtual method to retrieve field values from a record that matches specified search values.

function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant; virtual;
virtual __fastcall Variant Lookup(const AnsiString KeyFields, const Variant KeyValues, const AnsiString ResultFields);

This function: 

Checks whether the dataset is unidirectional, and if so, raises an EDatabaseError exception. 

Returns a Variant with the value false, indicating that a matching record was not found. 

Descendant classes that are not unidirectional override this method so that it locates the record where the fields identified by the comma-delimited string KeyFields have the values specified by the Variant or Variant array KeyValues. In classes that implement Lookup, it returns a Variant or Variant array that contains the value or values of the fields specified by the comma-delimited string ResultFields on the specified record. 


Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!