EPUB | CHM | PDF

TMySQLDataSet.Properties.FetchOnDemand

Top Previous Next

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