From 452dc930edb9a9549de6efad9dc2dbd686c523c6 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 23:39:17 +0000 Subject: [PATCH] Validate PANTGRUNS.EnteredBy against PEOPLE.Active --- db/schemas/lib/triggers/create/pantgrunts.m4 | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/db/schemas/lib/triggers/create/pantgrunts.m4 b/db/schemas/lib/triggers/create/pantgrunts.m4 index 8f7fef9..dbe2e47 100644 --- a/db/schemas/lib/triggers/create/pantgrunts.m4 +++ b/db/schemas/lib/triggers/create/pantgrunts.m4 @@ -110,6 +110,18 @@ CREATE OR REPLACE FUNCTION pantgrunts_func () END; END IF; + changequote({,})dnl + person_active({PANTGRUNTS}, {EnteredBy}, + {'Key (EID = (' + || NEW.EID + || '): Value (CommID) = (' + || NEW.commid + || '): Value (Source) = (' + || NEW.source + || ')'}) + changequote(`,')dnl + + RETURN NULL; END; $$; -- 2.34.1