Skip to content

    TDataSet.Lookup

    Search for a record and return matching values.

    Declaration

    Source position: db.pas line 1934

    public 
function TDataSet.Lookup(const KeyFields: string; 
                        const KeyValues: Variant; 
                        const ResultFields: string) : Variant;  virtual;

    Description

    Lookup always returns Null in TDataset. Descendents of TDataset can override this method to call TDataset.Locate to locate the record with fields KeyFields matching KeyValues and then to return the values of the fields in ResultFields. If ResultFields contains more than one fieldname (separated by semicolons), then the function returns an array. If there is only 1 fieldname, the value is returned directly.

    Errors

    If the dataset is unidirectional, then a EDatabaseError exception will be raised.

    See also

    Name Description
    TDataset.Locate Locate a record based on some key values.