Used to request all records of the query from database server when a dataset is being opened.
property FetchAll: boolean;
When set to True, all records of the query are requested from database server when a 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.