TCustomMyDataSet.FetchAll Property

Defines whether to request all records of the query from database server when the dataset is being opened.

Class

TCustomMyDataSet

Syntax

property FetchAll: boolean default True;

Remarks

The default value is True.

Note: When setting TCustomMyDataSet.FetchAll = False you should keep in mind that execution of such queries blocks current session. By default MyDAC will create additional session if it is necessary. But this can cause the following problems:

• Each additional session runs outside the transaction context thus TMyConnection.TCustomDAConnection.Commit and TMyConnection.TCustomDAConnection.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 FetchAll = False and temporary tables is impossible.
• TCustomMyDataSet.Lock cannot be used
• LockTable cannot be used

In order to avoid creating additional connection you can set Options to False.