Creating an ASA Trigger

To create an ASA trigger, you must have a connection to an ASA database.

Under an ASA connection profile in the Database Explorer, expand the Tables folder.
Select the table for which the trigger is to be created. Expand it, right-click the Triggers folder, and select New|Trigger to invoke the ASA Trigger Creation wizard.
The Create Trigger Skeleton page appears.
Choose the SQL Dialect option, unless you are using Transact SQL.
Enter the name of the trigger in the Name field. For example, titleInsert. Enter the Order Number if you are using Watcom SQL. The Order clause determines the order in which triggers of the same type (insert, update, or delete) are fired.
Enter an optional description in the Comments field, and click Next.
In the Execution Event dialog box, select Update, Insert, or Delete to indicate the condition under which the trigger is to be invoked when the associated table is modified.
If you are using Watcom SQL, you can select For Update Columns and choose those column check boxes that you want updated when the trigger is invoked.
Click Finish. The trigger definition skeleton appears in SQL Editor and is created in the database.