PgDAC

TPgQuery.FetchAll Property

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

Class

TPgQuery

Syntax

property FetchAll: boolean;

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.

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback