![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 25 Jan 2005 @ 18:09:43 GMT
Subj: | | Re: Syntax error in trigger code |
|
From: | | Victor Sokovin |
| This is the first trigger that we have tried so we may have overlooked the obvious but we get this message on the following code | |
| Syntax error: expected something between the ')' and the 'WHEN' keyword. | |
| If we remove the second WHEN and code following it the trigger will execute. Is there any idea as to what I have coded wrong? | |
The way I read the CREATE TRIGGER syntax diagram is that only one search_condition (and, therefore, the WHERE clause) is allowed in the
trigger definition. You can put all kinds of boolean logic in the condition, though, and you can have multiple DML statements (the syntax diagram
shows them as a ;-separated list). If this does not work, consider defining another trigger.
Regards,
Victor
| |