FireDAC.Stan.Option.TFDFetchMode
Delphi
TFDFetchMode = (fmManual, fmOnDemand, fmAll, fmExactRecsMax);
C++
enum DECLSPEC_DENUM TFDFetchMode : unsigned int { fmManual, fmOnDemand, fmAll, fmExactRecsMax };
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| enum | public | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | FireDAC.Stan.Option |
Description
Specifies how the result set records must be fetched into FireDAC internal data storage.
| Name | Description |
|---|---|
| fmManual |
The records are not fetched automatically by FireDAC. A programmer must write code to fetch records at appropriate times, using the following methods:
|
| fmOnDemand | The records are fetched automatically by FireDAC when they are required by the navigation or other dataset methods. At each request FireDAC fetches one or more record sets, containing RowsetSize records.
This mode allows to open large result sets without a significant delay, similarly to the |
| fmAll | All result set records are fetched automatically by FireDAC at the dataset Open call or at the first IADPhysCommand.Fetch call.
On a large result set it may take some time, but navigation through a dataset is fast because all records are stored in a FireDAC internal data storage. For many DBMSs, such as Microsoft SQL Server, MySQL Server, Sybase SQL Anywhere:
|