FireDAC.Stan.Option.TFDFetchOptions
Delphi
TFDFetchOptions = class (TFDCustomOptions)
C++
class PASCALIMPLEMENTATION TFDFetchOptions : public TFDCustomOptions
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | FireDAC.Stan.Option |
Description
The set of options for controlling the data and metadata fetching.
The TFDFetchOptions class represents the set of properties controlling how FireDAC components and Phys Layer command interfaces fetch the data and metadata:
- How to fetch (CursorKind, Mode, RowsetSize). For example, it is possible to fetch all result set records at once, or fetch records on demand.
- How to preserve resources (Unidirectional, AutoClose, Cache, AutoFetchAll).
- How to fetch and cache BLOB fields, nested record sets and metadata (Items, Cache).
- How to handle master-detail dataset relationship (DetailDelay, DetailOptimize, DetailCascade).
- A rowset paging (RecsMax, RecsSkip).
- TFDTable operation mode (CursorKind, LiveWindowParanoic, LiveWindowFastFirst).
- How to count records in a dataset (RecordCountMode).