CommitOnDisconnect
Description
Specifies whether PocketBuilder 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 in PocketBuilder.
Applies to
ODBC
UL9 UltraLite 9
UL10 UltraLite 10
Syntax
CommitOnDisconnect = ‘value’
Parameter
|
Description
|
|---|
value
|
Specifies whether PocketBuilder should
commit or roll back all previously uncommitted database updates
before disconnecting from a data source. Values are:
Yes (Default) PocketBuilder commits all uncommitted database updates
when an application closes or when an explicit DISCONNECT statement
is issued in a PocketBuilder script.
No PocketBuilder rolls back all uncommitted database updates
when an application closes or when an explicit DISCONNECT statement
is issued in a PocketBuilder script. With this setting, PocketBuilder
does not automatically commit updates when you disconnect from the
database.
|
Default
CommitOnDisconnect = ‘Yes’
Usage
Set CommitOnDisconnect to No if you want PocketBuilder to
roll back uncommitted database updates (instead of automatically
committing them when you disconnect from the database).
Examples
Example 1
To tell PocketBuilder 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.
PocketBuilder application script Type the following in a PocketBuilder script:
SQLCA.DBParm = "CommitOnDisconnect = 'No'"
