Data.DB.TDataSet.FindFirst

• Up to Parent: TDataSet

[–] Properties Type: function Visibility: public Source:

Data.DB.pas

Data.DB.hpp

Unit: Data.DB Parent: TDataSet

Delphi

function FindFirst: Boolean;

C++

bool __fastcall FindFirst();

Description

Implements a virtual method for positioning the dataset on the first record, respecting any filters.

FindFirst is intended to be used together with FindNext, FindLast and FindPrior in order to search for the first record using any filters. See the example.

Notes:

• This function is not implemented for TFDTable Live Data Windows mode.
• To conventionally navigate through a dataset use First, Last, Next and Prior.

Descendant classes override FindFirst to make the first record active, honoring any filters that are in effect. In descendant classes, FindFirst returns:

• True -- if the active record is successfully changed.
• False -- if the active record is not successfully changed.

Example

Here is a code snippet that shows how to use FindFirst and FindNext to search for a record using a filtering expression:

Delphi:

FDQuery1.Filter := 'amount >= 10000';
if FDQuery1.FindFirst then
   repeat
    // do something
   until not FDQuery1.FindNext;

C++:

FDQuery1->Filter="amount >= 10000";
if (FDQuery1->FindFirst()){
   do {
    // do something
   }
   while (FDQuery1->FindNext());
}

See Also

• Data.DB.TDataSet.Filter
• Data.DB.TDataSet.Filtered
• Data.DB.TDataSet.OnFilterRecord
• Data.DB.TDataSet.FindLast
• Data.DB.TDataSet.FindNext
• Data.DB.TDataSet.FindPrior
• Data.DB.TDataSet.First