FireDAC.Comp.DataSet.TFDDataSet.FetchAll

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

procedure FetchAll;

C++

void __fastcall FetchAll();

Properties

Type Visibility Source Unit Parent
procedure
function
public
FireDAC.Comp.DataSet.pas
FireDAC.Comp.DataSet.hpp
FireDAC.Comp.DataSet TFDDataSet

Description

Retrieves all records from the current resultset and stores them into an internal DatS table.

Call FetchAll to retrieve all records that are not yet fetched from the current result set. Calling FetchAll allows:

  • Releasing server resources faster, because FetchAll implicitly closes the DBMS cursor. That does not deactivate the dataset.
  • Releasing the Call Level Interface result set buffer, allowing you to execute the next command and get the result set. That is applicable for some DBMS, like SQL Server and MySQL.

If FetchOptions.Mode is set to fmAll, then the dataset automatically calls FetchAll when Open is called.

See Also

Sample