From aca2a59a1262c247ee6e9048d576963c98daa87c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 23:33:03 +0000 Subject: [PATCH] Validate COMM_MEMB_LOG.MadeBy against PEOPLE.Active --- db/schemas/lib/triggers/create/comm_memb_log.m4 | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/db/schemas/lib/triggers/create/comm_memb_log.m4 b/db/schemas/lib/triggers/create/comm_memb_log.m4 index 8793100..53490c8 100644 --- a/db/schemas/lib/triggers/create/comm_memb_log.m4 +++ b/db/schemas/lib/triggers/create/comm_memb_log.m4 @@ -40,6 +40,17 @@ CREATE OR REPLACE FUNCTION comm_memb_log_func () cannot_change(`COMM_MEMB_LOG', `CommMLID') END IF; + changequote({,})dnl + person_active({COMM_MEMB_LOG}, {MadeBy}, + {'Key (CommMLID = (' + || NEW.commmlid + || '): Value (DateOfUpdate) = (' + || NEW.dateofupdate + || '): Value (AnimId) = (' + || NEW.animid + || ')'}) + changequote(`,')dnl + RETURN NULL; END; $$; -- 2.34.1