Row Level Trigger Support
Advantage supports row-level triggers. Row-level triggers are fired once for each row that an update operation affects. For example, if a table contains multiple records with the deptnum field equal to 5, and the following SQL statement is executed:
DELETE FROM mytable WHERE deptnum = 5
a trigger will fire once for each row that is affected by the DELETE operation (each row in which deptnum is equal to 5).