FireDAC.Comp.DataSet.TFDDataSet.FetchAll

• Up to Parent: TFDDataSet

Delphi

procedure FetchAll;

C++

void __fastcall FetchAll(void);

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

• FireDAC.Stan.Option.TFDFetchOptions.Mode

Sample

• FireDAC TFDMemTable Incremental Fetching sample