Chapter 5 Building Triggers and Procedures

Modifying a trigger template

You can modify both your templates and those that are provided with PowerDesigner.

Steps To modify a trigger template:

  1. Open the trigger template property sheet in one of the following ways:
  2. To modify a DBMS trigger template: select Database→Edit Current DBMS to open the DBMS definition file in the resource editor, and then click the Trigger Templates tab.
  3. To modify a model trigger template: select Model→Triggers→Trigger Templates to open the List of User-Defined Trigger Templates.
  4. Click a trigger template in the list, and then click the Properties tool to open its property sheet.
  5. Click the Definition tab and modify the trigger definition code. You can add trigger template items, use PDM variables and macros and various other tools available from the toolbar. For more information, see "Using the Definition tab toolbar".
  6. You can also modify other of the trigger template's properties. For a full list of the properties available, see "Trigger template properties".
  7. Click OK in each of the dialog boxes.

    If you have created DBMS trigger template, a confirmation box will appear, asking if you want to save the changes to the DBMS.

    Click Yes to confirm the template creation.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.