TPgTable.FetchAll

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

Unit

Syntax

Remarks

When set to True, all records of the query are requested from database server when the dataset is being opened. When set to False, records are retrieved when a data-aware component or a program requests it. If a query can return a lot of records, set this property to False if initial response time is important.

Opening a dataset in FetchAll = False mode requires an active transaction.When the FetchAll property is False, the first call to TMemDataSet.Locate and TMemDataSet.LocateEx methods may take a lot of time to retrieve additional records to the client side.