The AutoCommit and Lock (Isolation Level) preferences are properties of the default Transaction object, SQLCA. For AutoCommit and Lock to take effect in the PocketBuilder development environment, you must specify them before you connect to a database. Changes made to these preferences after the connection occurs have no effect on the current connection.
To set AutoCommit and Lock before PocketBuilder connects to your database, you specify their values in the Database Profile Setup dialog box for your connection.
To set AutoCommit and Lock (Isolation Level) in
a database profile:
Display the Database Profiles dialog box.
Click the plus sign (+) to the left of the interface you are using, or double-click the interface name.
The list expands to display the database profiles defined for your interface.
Select the name of the profile you want and click Edit.
The Database Profile Setup dialog box for the selected profile displays.
On the Connection tab page, supply values for one or both of the following:
Isolation Level Select the isolation level you want to use for this connection from the Isolation Level drop-down list. (The Isolation Level drop-down list contains valid lock values for your interface.)
AutoCommit Mode The setting of AutoCommit controls whether PocketBuilder issues SQL statements outside (True) or inside (False) the scope of a transaction. Select the AutoCommit Mode check box to set AutoCommit to True or clear the AutoCommit Mode check box (the default) to set AutoCommit to False.
Figure 18-1: Connection page showing Isolation Level settings
(Optional) Click the Preview tab if you want to see the PowerScript connection syntax generated for Lock and AutoCommit.
PocketBuilder generates correct PowerScript connection syntax for each option you set in the Database Profile Setup dialog box. You can copy this syntax directly into a PocketBuilder application script.
For instructions, see “Copying DBParm syntax from the Preview tab”.
Click OK to close the Database Profile Setup dialog box.
PocketBuilder saves your settings in the database profile entry in the registry.
