FireDAC.Comp.DataSet.TFDDataSet.FetchAll
| [–] Properties | |
|---|---|
| Type: procedure function
| |
| Visibility: public | |
| Source: FireDAC.Comp.DataSet.pas FireDAC.Comp.DataSet.hpp
| |
| Unit: FireDAC.Comp.DataSet | |
| Parent: TFDDataSet | |
Delphi
procedure FetchAll;
C++
void __fastcall FetchAll();
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.