FireDAC.Stan.Option.TFDFetchOptions.AutoFetchAll

• Up to Parent: TFDFetchOptions

Delphi

property AutoFetchAll: TFDAutoFetchAll read GetAutoFetchAll  write SetAutoFetchAll stored IsAFAS default afAll;

C++

__property TFDAutoFetchAll AutoFetchAll = {read=GetAutoFetchAll, write=SetAutoFetchAll, stored=IsAFAS, default=0};

Properties

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

Description

Controls the automatic fetching of all records from a dataset cursor before disconnecting a command.

Use the AutoFetchAll property to control the automatic fetching of all records from a dataset cursor before disconnecting an associated command. The default value is afAll. A command may be disconnected, when one of the following occurs:

• A connection object is set to offline mode.
• If the amount of active commands on the same connection object is greater than MaxCursors, then less used commands will be disconnected.
• On some DBMSs before a transaction will be committed, where a cursor has been opened.

The property can have the following values:

Value	Description
afAll	The FetchAll method will be called.
afTruncate	Fetching from the cursor will be finished. Previously fetched records will be preserved.
afDisable	An exception is raised, if not all records are fetched.

See Also

• Managing Transactions
• FireDAC.Stan.Option.TFDFetchOptions.Mode
• FireDAC.Stan.Option.TFDFetchOptions.AutoClose