TQuery.RequestLive
Specifies whether an application expects to receive a live result set from the Borland Database Engine (BDE) when the query executes.
property RequestLive: Boolean;
Description
Set RequestLive to specify whether or not the BDE should attempt to return a live result set to the application. RequestLive is False by default, meaning that a query always returns a read-only result set.
Set RequestLive to True to request a live result set. Setting RequestLive to True does not guarantee that a live result set is returned by the BDE. The BDE returns a live result set only if the SELECT syntax of the query conforms to the syntax requirements for a live result set. If RequestLive is True, but the syntax does not conform to the requirements, the BDE returns a read-only result set for Paradox or dBASE, or an error return code for remote servers.
After activating the TQuery, inspect the CanModify property to determine whether the request for a live result set was successful.
Note: All multi-table queries return read-only result sets. Other conditions may cause a query to return a read-only result set. For local tables (such as dBASE and Paradox), see the local SQL help file for rules governing live result sets (updatable queries). For other table types (such as InterBase, Oracle, and Sybase), consult the documentation for the specific database system.
