TPgDataSetOptions.CursorWithHold Property

Used to open query in the FetchAll=False mode without transaction.

Class

TPgDataSetOptions

Syntax

property CursorWithHold: boolean default False;

Remarks

Use the CursorWithHold option to open query in the FetchAll=False mode without transaction.

When this option is False (default), an active transaction is required to open a query in the FetchAll=False mode. If there is no active transaction, PgDAC opens additional internal connection and starts transaction on this connection.

When this option is True, PgDAC uses DECLARE CURSOR ... WITH HOLD statement to open the query. In this case no active transaction is required but this may take additional server resources.