Kbase P71005: Dynamics. Duplication the Schema Logic Technique
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/03/2004 |
|
Status: Unverified
GOAL:
Dynamics. Duplication the Schema Logic Technique
FIX:
If you have legacy application, any complex business logic that is now in the database triggers should be removed.
If they must stay in the database triggers, they should be duplicated in the Logic Procedures.
This assures that errors are properly handled, returned to the client and displayed to the user.
To duplicate the trigger logic:
1. Copy code from the schema trigger into one of the validation procedures in the SDO logic procedure.
2. Modify the code to use the messagng capabilities of Dynamics to return errors to the client.