sc_log creator column

Scriptcase 9 General
#1

Log system working well. The column “creator” populates with ‘Scriptcase’. Is there a way to change what value goes into that column?
I’m using V8.
Thanks

#2

Seems creator =“Scriptcase” is hard coded in sc_log application.

I “bypass” this under MySQL (but will work with other databases) using a trigger ON BEFORE INSERT.

Per example

delimiter $
CREATE TRIGGER change_creator
  BEFORE INSERT ON Sec_log
  FOR EACH ROW
BEGIN
  IF (NEW.creator ='Scriptcase') THEN 
  SET NEW.creator = 'Security';
END IF;   
END$
delimiter ;
#3

Hello !

I don’t know TRIGGER function but I like it !

VERY USEFUL !

Thanks

#4

Your welcome :wink:

Note that using database triggers on function calls may be problematic to maintain in the long run between “data management” on the program side (scriptcase) and on the database side.