CommitOnDisconnect

Description

Specifies whether InfoMaker 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 InfoMaker should commit or roll back all previously uncommitted database updates before disconnecting from a data source. Values are: Yes (Default) InfoMaker commits all uncommitted database updates when an application closes. No InfoMaker rolls back all uncommitted database updates when an application closes. With this setting, InfoMaker does not automatically commit updates when you disconnect from the database.

Parameter

Description

value

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

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

Default

CommitOnDisconnect='Yes'

Usage

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

Examples

Example 1

To tell InfoMaker to roll back uncommitted database updates instead of committing them when disconnecting from the database, clear the Commit On Disconnect check box on the Connection page in the Database Profile Setup dialog box.