Define the Table Override Triggers SQL Code

You can use the Code tab in the Triggers dialog to display the SQL code in the selected table override trigger. You can change the trigger code.

To define the triggers SQL code

  1. Click Triggers, Table Triggers on the Database menu.

    The Triggers dialog opens.

  2. Click the Code tab.

    The code for the selected table override trigger appears. You can change the trigger code.

  3. Click the Macro Toolbox button.

    The Macro Toolbox opens. You can select a macro to add to the trigger.

  4. Click OK.

    Your changes are saved and the Triggers dialog closes.

    Note: Click Cancel to close the dialog without saving your changes.

You can complete the fields on the General and Expanded tabs and then optionally select the Comment or UDP tab to add a comment or user defined property.


Copyright © 2009 CA. All rights reserved. Email CA about this topic