Specifies whether the rows transferred across the network by portions.
Syntax:
property FetchOnDemand : boolean default false;
Description:
Use FetchOnDemand property to activate the rows transfer across the network by portions specified by FetchRows property.
When setting FetchOnDemand = True please keep in mind that DAC for MySQL will create additional session in order not to block current session. But this can cause the following problems:
▪Each additional session runs outside of the transaction context, thus TmySQLDatabase.Commit and TmySQLDatabase.Rollback operations in main session won't apply changes made in additional sessions.
▪Temporary tables created in one session are not accessible from other sessions, therefore simultaneous using of FetchOnDemand = True and temporary tables is impossible.
See also: FetchRows property