Contents
For the 1st option, you would execute a SOQL query to return the Order fields you need, including relationship fields for the related object fields. For the 2nd option, your code would almost be identical but you would use the formula field on Order__c, rather than relatedObject2__r.Name.
Can a BEFORE trigger reference a generated column?
The NEW variable of a Before trigger cannot reference a generated column. The triggered-SQL-statement can reference database objects other than the table upon which the trigger is declared. If any of these database objects is dropped, the trigger is invalidated.
What does referencing new row do in trigger?
REFERENCING NEW ROW allows you to reference the new value of a column during an INSERT or UPDATE trigger. The ROW AS keywords are optional. For an UPDATE, you can specify both OLD and NEW in the same REFERENCING clause, as follows: REFERENCING OLD oldalias NEW newalias.
When to use referencing clause in trigger InterSystems?
Optional — A REFERENCING clause can only be used when LANGUAGE is SQL. A REFERENCING clause allows you to specify an alias that you can use to reference a column. REFERENCING OLD ROW allows you reference the old value of a column during an UPDATE or DELETE trigger.
Do you need a unique name for a trigger?
Trigger names do not need to be unique with respect to other schema objects, such as tables, views, and procedures. For example, a table and a trigger can have the same name (however, to avoid confusion, this is not recommended). When Is the Trigger Fired?
Can a table and trigger have the same name?
Trigger names must be unique with respect to other triggers in the same schema. Trigger names do not need to be unique with respect to other schema objects, such as tables, views, and procedures. For example, a table and a trigger can have the same name (however, to avoid confusion, this is not recommended).
Do you need to define triggers in Oracle?
Do not define triggers that duplicate features already built into Oracle Database. For example, do not define triggers to reject bad data if you can do the same checking through declarative integrity constraints. Limit the size of triggers.