FireDAC.Comp.Client.TFDCustomCommand.Fetch

• Up to Parent: TFDCustomCommand

[–] Properties Type:

procedure

function

Visibility: public Source:

FireDAC.Comp.Client.pas

FireDAC.Comp.Client.hpp

Unit: FireDAC.Comp.Client Parent: TFDCustomCommand

Delphi

procedure Fetch(ATable: TFDDatSTable; AAll: Boolean = True; ABlocked: Boolean = False); overload;

C++

void __fastcall Fetch(Firedac::Dats::TFDDatSTable* ATable, bool AAll = true, bool ABlocked = false)/* overload */;

Description

Fetches rows from the current command cursor.

The Fetch method fetches rows from the current command cursor in the DatS table. To call Fetch, the command must be opened (in csActive state) by a call to Open, otherwise an exception is raised.

At each call up to FetchOptions.RowsetSize rows are fetched. If FetchOptions.AutoClose is True, FireDAC automatically calls the CloseAll method after fetching the last row.

If fiBlobs is in FetchOptions.Items, then the values of the BLOB field are fetched together with other field values. If fiDetails is in FetchOptions.Items, then the nested dataset is fetched together with other field values. While fetching, the field values are converted according to FormatOptions and stored into the DatS rows.

Example

var
  oTab: TADDatSTable;
...
  ADCommand1.CommandKind := skStoredProc;
  ADCommand1.CommandText.Text := 'SEL_CUST_PROC';
  oTab := ADCommand1.Define;
  try
    ADCommand1.Open;
    repeat
      oTab.Clear;
      ADCommand1.Fetch(oTab, False);
      // process next rowset
    until ADCommand1.RowsAffected = 0;
  finally
    oTab.Free;
  end;

See Also

• FireDAC.Stan.Option.TFDFetchOptions
• FireDAC.Comp.Client.TFDCustomCommand.Close
• FireDAC.Comp.Client.TFDCustomCommand.CloseAll
• FireDAC.Comp.Client.TFDCustomCommand.Open
• FireDAC.Comp.Client.TFDCustomCommand.Active

Sample

• FireDAC TFDMemTable Incremental Fetching sample