602SQL Documentation Index  

Trigger Designer

The text editor allows the creation and modification of triggers in the 602SQL Client. A new trigger body is created by the wizard that allows you (in steps) to choose the table, trigger type (INSERT, UPDATE or DELETE) and other parameters.

You can also create, modify and delete triggers with the CREATE TRIGGER, ALTER TRIGGER and DROP TRIGGER SQL statements.

Testing a Trigger

You can check the trigger at anytime for syntax errors using the Design / Compile action. If a syntax error is found, the error is displayed and the cursor is set near the error occurrence in the editor.

Trigger functionality may be tested with SQL statements (e.g. in the SQL console window), or by editing the corresponding table in the grid.