Prepare Commit Behavior Property

ADO and SQL Server

ADO and SQL Server

Prepare Commit Behavior Property

The Prepare Commit Behavior property specifies how committing a transaction affects prepared commands.

Applies To
Connection Object
Syntax

object.Properties("Prepare Commit Behavior")

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Integer that specifies how committing a transaction affects prepared commands, as specified in Settings

Settings

One of the following settings:

Constant Description
DBPROPVAL_CB_DELETE Committing a transaction deletes prepared commands. The application must reprepare commands before executing them.
DBPROPAL_CB_PRESERVE Committing a transaction preserves prepared commands. The application can reexecute commands without repreparing them.

Data Type

adInteger

Modifiable

Read-only

OLE DB Property

DBPROP_PREPARECOMMITBEHAVIOR

See Also

Prepare Abort Behavior Property

Preserve on Abort Property

Preserve on Commit Property