When the application is already running in production mode and triggers need to be added at the table or field level, you do not have to recompile your application code. Schema triggers are not used in calculating Table or Index CRCs. Therefore, adding the triggers will not cause the CRCs to change .r code will not be affected. For further information refer to Article:
There are however
Trigger CRC values, that can be involved with schema triggers.
- When the triggers are first created, a choice of whether or not CRCs need to be used to manage trigger code.
- When the "Check CRC" check-box on the Table Triggers dialog is selected, Progress will verify before running the trigger if CRC of the associated table has changed. If CRC of the table changed, the trigger will not be fired.
- These CRCs are separate CRC values that are computed for the trigger routines themselves.
- The Data Dictionary calculates these r-code CRC values and stores them in the the following metaschema tables:
- _File-Trig (for table triggers) and
- _Field-Trig (for field triggers).
When a database event occurs that causes a schema trigger to fire, when CRC checking is enabled,
the CRC value of the trigger code is compared to the CRC value stored in the metaschema file. When they do not match, Progress returns a run-time error. In which case the trigger-code needs to be recompiled against the current application schema.