aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_guest_init_name
Parameters
Name
Type
Mode
Definition
DECLARE title_name text; BEGIN if fn_sys_param('GUEST_PROFILE', 'NAME_FORCE_UPPER', false) then new.last_name = upper(new.last_name); new.first_name = upper(new.first_name); new.middle_name = upper(new.middle_name); end if; if (old.last_name <> new.last_name) or (old.first_name <> new.first_name) or (old.middle_name is distinct from new.middle_name) or (old.title_id is distinct from new.title_id) then title_name = (select name from title where id = new.title_id); new.full_name = fn_fullname(new.last_name, new.first_name, new.middle_name, title_name); end if; RETURN NEW; END