Chapter 6 Building Triggers and Procedures
The Definition tab allows you to enter code for the trigger. It contains the following properties:
| Property | Description |
|---|---|
| Template | Template on which the trigger is based |
| User-defined | This button is automatically depressed when you modify the definition of a trigger, that is to say the trigger template code. You can click the User-Defined button to restore the trigger definition as it is provided in the template |
| Time | Time attribute of the template. The content of the list depends on the DBMS |
| Event | Event attribute of the template. The content of the list depends on the DBMS |
| Order | Firing order of trigger |
You can customize the trigger time and event, and you can also handle multiple events on a single trigger.
The time and event lists are filled with the values defined in the trigger template and the values defined in the Time and Event entries in the Trigger category of the DBMS editor. For example, if you define Select as an event in the DBMS definition file, it will appear in the list of events.
For more information about triggers with multiple event, see Defining triggers with multiple events.
For information about the Definition tab toolbar, see SQL Code Definition Toolbars.
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |