From 23602a112ea89123fed339585a950b4d8ae87dc3 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 23:30:41 +0000 Subject: [PATCH] Validate BIOGRAPHY_LOG.MadeBy against PEOPLE.Active --- db/schemas/lib/triggers/create/biography_log.m4 | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/db/schemas/lib/triggers/create/biography_log.m4 b/db/schemas/lib/triggers/create/biography_log.m4 index cbcb232..2d13511 100644 --- a/db/schemas/lib/triggers/create/biography_log.m4 +++ b/db/schemas/lib/triggers/create/biography_log.m4 @@ -40,6 +40,17 @@ CREATE OR REPLACE FUNCTION biography_log_func () cannot_change(`BIOGRAPHY_LOG', `BLID') END IF; + changequote({,})dnl + person_active({BIOGRAPHY_LOG}, {MadeBy}, + {'Key (BLID = (' + || NEW.blid + || '): Value (DateOfUpdate) = (' + || NEW.dateofupdate + || '): Value (AnimId) = (' + || NEW.animid + || ')'}) + changequote(`,')dnl + RETURN NULL; END; $$; -- 2.34.1