CommitOnDisconnect

Description

Specifies whether DataWindow Designer should commit (the default) or roll back all previously uncommitted database updates before disconnecting from a data source.

When to specify CommitOnDisconnect You must specify a value for CommitOnDisconnect before connecting to the database.

Applies to

All database interfaces

Syntax

CommitOnDisconnect = 'value'

Parameter	Description
value	Specifies whether DataWindow Designer should commit or roll back all previously uncommitted database updates before disconnecting from a data source. Values are: Yes (Default) DataWindow Designer commits all uncommitted database updates when an application closes. No DataWindow Designer rolls back all uncommitted database updates when an application closes. With this setting, DataWindow Designer does not automatically commit updates when you disconnect from the database.

Parameter

Description

value

Specifies whether DataWindow Designer should commit or roll back all previously uncommitted database updates before disconnecting from a data source. Values are:

Yes (Default) DataWindow Designer commits all uncommitted database updates when an application closes.
No DataWindow Designer rolls back all uncommitted database updates when an application closes. With this setting, DataWindow Designer does not automatically commit updates when you disconnect from the database.

Default

CommitOnDisconnect = 'Yes'

Usage

Set CommitOnDisconnect to No if you want DataWindow Designer to roll back uncommitted database updates (instead of automatically committing them when you disconnect from the database).

Examples

Example 1

To tell DataWindow Designer to roll back uncommitted database updates instead of committing them when disconnecting from the database:

Database profile Clear the Commit On Disconnect check box on the Connection tab in the Database Profile Setup dialog box.

Application Type the following in code:

SQLCA.DbParameter = "CommitOnDisconnect='No'"