Used to open query in the FetchAll=False mode without transaction.
property CursorWithHold: boolean default False;
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.