Consultor Eletrônico



Kbase 17569: Is another compile needed after adding a schema trigger?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/05/1998
Is another compile needed after adding a schema trigger?

This Knowledgebase entry explains the impact adding schema triggers
has on your application environment.

If you already have your application running in production mode and
decide later to add schema triggers (at the file or field level),
you do not have to recompile your application code. Schema triggers
are not used in calculating database CRCs. Therefore, adding the
triggers will not cause the CRCs to change and your .r code will not
be affected.

There are CRC values, however, that can be involved with schema
triggers. When the triggers are first created, you have the choice
of whether or not you want CRCs used to manage your trigger code.
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 _File-Trig (for table triggers)
and _Field-Trig (for field triggers). When a database event
occurs in your application that causes a schema trigger to fire,
if CRC checking is enabled, the CRC value of the trigger code is
compared to the CRC value stored in the metaschema file. If they
do not match, Progress returns a run-time error.

For more information regarding r-code CRCs and how they relate to
triggers, please refer to the Programming Handbook, (V7 & v8) in
appendix A.


Progress Software Technical Support Note # 17569