From f2fcea1ac01aa77f3dcdf0490702e73ccf51413a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 20 May 2026 14:40:49 +0000 Subject: [PATCH] Declare variables needed to to check focal participantion as globals --- db/schemas/lib/triggers/create/follows.m4 | 20 +++++++++++--------- 1 file changed, 11 insertions(+), 9 deletions(-) diff --git a/db/schemas/lib/triggers/create/follows.m4 b/db/schemas/lib/triggers/create/follows.m4 index 392f2f7..c2449a5 100644 --- a/db/schemas/lib/triggers/create/follows.m4 +++ b/db/schemas/lib/triggers/create/follows.m4 @@ -29,6 +29,17 @@ CREATE OR REPLACE FUNCTION follows_func () LANGUAGE plpgsql sdb_function_set_search_path AS $$ + DECLARE + -- ROLES + a_pid roles.pid%TYPE; + a_role roles.role%TYPE; + a_participant roles.participant%TYPE; + -- EVENTS + a_eid events.eid%TYPE; + a_behavior events.behavior%TYPE; + a_start events.start%TYPE; + a_stop events.stop%TYPE; + BEGIN -- Function for follows insert and update triggers -- @@ -106,15 +117,6 @@ CREATE OR REPLACE FUNCTION follows_func () a_birthdate biography_data.birthdate%TYPE; a_entrydate biography_data.entrydate%TYPE; a_departdate biography_data.departdate%TYPE; - -- ROLES - a_pid roles.pid%TYPE; - a_role roles.role%TYPE; - a_participant roles.participant%TYPE; - -- EVENTS - a_eid events.eid%TYPE; - a_behavior events.behavior%TYPE; - a_start events.start%TYPE; - a_stop events.stop%TYPE; -- ARRIVALS a_arid arrivals.arid%TYPE; a_cycle arrivals.cycle%TYPE; -- 2.34.1