Step 4: specify the default global variable type for SQLCA

In the Application painter, you must specify the user object you defined as the default global variable type for SQLCA. When you execute your application, this tells PowerBuilder to use your standard class user object instead of the built-in system Transaction object.

NoteUsing your own Transaction object instead of SQLCA This procedure assumes that your application uses the default Transaction object SQLCA, but you can also declare and create an instance of your own Transaction object and then write code that calls the user object as a property of your Transaction object. For instructions, see the chapter on working with user objects in the PowerBuilder Users Guide.

StepsTo specify the default global variable type for SQLCA:

  1. Click the Open button in the PowerBar, or select File>Open from the menu bar.

    The Open dialog box displays.

  2. Select Applications from the Object Type drop-down list. Choose the application where you want to use your new user object and click OK.

    The Application painter workspace displays.

  3. Select the General tab in the Properties view. Click the Additional Properties button.

    The Additional Properties dialog box displays.

  4. Click the Variable Types tab to display the Variable Types property page.

  5. In the SQLCA box, specify the name of the standard class user object you defined in Steps 1 through 3:

    A sample shows the Application painter open with the variable types tab open and the variable types property page displayed. The first box  at the top of the page is labeled Sequel C A. The entry in the box is u _ trans _ database.
  6. Click OK or Apply.

    When you execute your application, PowerBuilder will use the specified standard class user object instead of the built-in system object type it inherits from.