/********************************************************************* * Copyright (C) 2000 by Progress Software Corporation ("PSC"), * * 14 Oak Park, Bedford, MA 01730, and other contributors as listed * * below. All Rights Reserved. * * * * The Initial Developer of the Original Code is PSC. The Original * * Code is Progress IDE code released to open source December 1, 2000.* * * * The contents of this file are subject to the Possenet Public * * License Version 1.0 (the "License"); you may not use this file * * except in compliance with the License. A copy of the License is * * available as of the date of this notice at * * http://www.possenet.org/license.html * * * * Software distributed under the License is distributed on an "AS IS"* * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. You* * should refer to the License for the specific language governing * * rights and limitations under the License. * * * * Contributors: MIP Holdings (Pty) Ltd ("MIP") * * PSC * * * *********************************************************************/ TRIGGER PROCEDURE FOR WRITE OF gsc_global_control OLD BUFFER o_gsc_global_control. /* Created automatically using ERwin ICF Trigger template db/af/erw/afercustrg.i Do not change manually. Customisations to triggers should be placed in separate include files pulled into the trigger. ICF auto generates write trigger custom include files. Delete or create customisation include files need to be created manually. Be sure to put the hook in ERwin directly so as not to have you changes overwritten. User defined Macro (UDP) Summary (case sensitive) gsc_global_control Expands to full table name, e.g. gsm_user %TableFLA Expands to table unique code, e.g. gsmus %TableObj If blank or not defined expands to table_obj with no prefix (framework standard) If defined, uses this field as the object field If set to "none" then indicates table does not have an object field XYZ Do not define so we can compare against an empty string See docs for explanation of replication macros */ &SCOPED-DEFINE TRIGGER_TABLE gsc_global_control &SCOPED-DEFINE TRIGGER_FLA gscgc &SCOPED-DEFINE TRIGGER_OBJ global_control_obj DEFINE BUFFER lb_table FOR gsc_global_control. /* Used for recursive relationships */ DEFINE BUFFER lb1_table FOR gsc_global_control. /* Used for lock upgrades */ /* Standard top of WRITE trigger code */ {af/sup/aftrigtopw.i} /* properform fields if enabled for table */ IF CAN-FIND(FIRST gsc_entity_mnemonic WHERE gsc_entity_mnemonic.entity_mnemonic = 'gscgc':U AND gsc_entity_mnemonic.auto_properform_strings = YES) THEN RUN af/app/afpropfrmp.p (INPUT BUFFER gsc_global_control:HANDLE). /* Generated by ICF ERwin Template */ /* gsm_currency is the default currency for gsc_global_control ON CHILD UPDATE SET NULL */ IF NEW gsc_global_control OR gsc_global_control.default_currency_obj <> o_gsc_global_control.default_currency_obj THEN DO: IF NOT(CAN-FIND(FIRST gsm_currency WHERE gsc_global_control.default_currency_obj = gsm_currency.currency_obj)) THEN DO: ASSIGN gsc_global_control.default_currency_obj = 0 . END. END. /* Generated by ICF ERwin Template */ /* gsc_nationality is the default for gsc_global_control ON CHILD UPDATE RESTRICT */ IF NEW gsc_global_control OR gsc_global_control.default_nationality_obj <> o_gsc_global_control.default_nationality_obj THEN DO: IF NOT(CAN-FIND(FIRST gsc_nationality WHERE gsc_global_control.default_nationality_obj = gsc_nationality.nationality_obj)) THEN DO: /* Cannot update child because parent does not exist ! */ ASSIGN lv-error = YES lv-errgrp = "AF ":U lv-errnum = 103 lv-include = "gsc_global_control|gsc_nationality":U. RUN error-message (lv-errgrp, lv-errnum, lv-include). END. END. /* Generated by ICF ERwin Template */ /* gsm_country is the default for gsc_global_control ON CHILD UPDATE RESTRICT */ IF NEW gsc_global_control OR gsc_global_control.default_country_obj <> o_gsc_global_control.default_country_obj THEN DO: IF NOT(CAN-FIND(FIRST gsm_country WHERE gsc_global_control.default_country_obj = gsm_country.country_obj)) THEN DO: /* Cannot update child because parent does not exist ! */ ASSIGN lv-error = YES lv-errgrp = "AF ":U lv-errnum = 103 lv-include = "gsc_global_control|gsm_country":U. RUN error-message (lv-errgrp, lv-errnum, lv-include). END. END. /* Generated by ICF ERwin Template */ /* gsc_language gsc_global_control ON CHILD UPDATE RESTRICT */ IF NEW gsc_global_control OR gsc_global_control.default_language_obj <> o_gsc_global_control.default_language_obj THEN DO: IF NOT(CAN-FIND(FIRST gsc_language WHERE gsc_global_control.default_language_obj = gsc_language.language_obj)) THEN DO: /* Cannot update child because parent does not exist ! */ ASSIGN lv-error = YES lv-errgrp = "AF ":U lv-errnum = 103 lv-include = "gsc_global_control|gsc_language":U. RUN error-message (lv-errgrp, lv-errnum, lv-include). END. END. IF NOT NEW gsc_global_control AND gsc_global_control.{&TRIGGER_OBJ} <> o_gsc_global_control.{&TRIGGER_OBJ} THEN DO: ASSIGN lv-error = YES lv-errgrp = "AF":U lv-errnum = 13 lv-include = "table object number":U. RUN error-message (lv-errgrp,lv-errnum,lv-include). END. /* Customisations to WRITE trigger */ {icf/trg/gscgctrigw.i} /* Update Audit Log */ IF CAN-FIND(FIRST gsc_entity_mnemonic WHERE gsc_entity_mnemonic.entity_mnemonic = 'gscgc':U AND gsc_entity_mnemonic.auditing_enabled = YES) THEN RUN af/app/afauditlgp.p (INPUT "WRITE":U, INPUT "gscgc":U, INPUT BUFFER gsc_global_control:HANDLE, INPUT BUFFER o_gsc_global_control:HANDLE). /* Standard bottom of WRITE trigger code */ {af/sup/aftrigendw.i}