FireDAC.Stan.Option.TFDFetchOptions.Cache

• Up to Parent: TFDFetchOptions

Delphi

property Cache: TFDFetchItems read GetCache write SetCache

C++

__property TFDFetchItems Cache = {read=GetCache, write=SetCache, stored=IsCS, default=7};

Properties

Type	Visibility	Source	Unit	Parent
property	published	FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp	FireDAC.Stan.Option	TFDFetchOptions

Description

Controls what kind of data to cache in the memory.

Use the Cache property to control what kind of data and metadata to cache in the internal data storage.

Option	Description
fiBlobs	If included, then the BLOB field values are not discarded from the memory after usage. If excluded, then, after changing the current dataset record, BLOB field values in the current record will be discarded.
fiDetails	If included: For a nested dataset, an associated nested cursor will not be discarded from the memory after changing a parent dataset record. For a detail dataset, an associated detail record will not be discarded from the memory after changing a master dataset record.
fiMeta	If included, then the command metadata is not discarded from the memory after usage. If excluded, then after fetching and using required metadata (eg, primary key fields), it will be discarded from the cache.

The default value is [fiBlobs, fiDetails, fiMeta], meaning that all data and metadata will be cached after usage. 

Note: Excluding items from Cache does not affect already fetched data or metadata.

See Also

• Unique Identifying Fields
• Fetching Rows
• Master-Detail Relationship
• FireDAC.Stan.Option.TFDFetchOptions.Items