Coding PowerScript to set values for AutoCommit and Lock

Another way to specify the AutoCommit and Lock properties in a script is by coding PowerScript to assign values to the AutoCommit and Lock properties of the Transaction object.

StepsTo set the AutoCommit and Lock properties in a PocketBuilder script:

  1. Open the application script in which you want to set connection properties.

    For instructions, see the User’s Guide.

  2. Use the following PowerScript syntax to set the AutoCommit and Lock properties. (This syntax assumes you are using the default Transaction object SQLCA, but you can also define your own Transaction object.)

    SQLCA.AutoCommit = value
    
    SQLCA.Lock = "value"
    

    For more information, see AutoCommit or Lock in the online Help.

  3. Compile the script to save your changes.

    For instructions, see the User’s Guide.