Skip to content

Instantly share code, notes, and snippets.

@AndyDaSilva52

AndyDaSilva52/MGCLI.T_CLI_GLO_AGENDAINTMULTI.sql

Created July 30, 2019 20:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AndyDaSilva52/b6a656378a4afd2775fa58439ddc9820 to your computer and use it in GitHub Desktop.
Save AndyDaSilva52/b6a656378a4afd2775fa58439ddc9820 to your computer and use it in GitHub Desktop.
Download ZIP
#Mega Agendas de Integração - TRIGGER definir sempre um usuário fixo que é utilizado na integração dos movimentos - Modelo que permite múltiplas agendas rodando ao mesmo tempo em diferentes servidores#MegaERP
Raw
MGCLI.T_CLI_GLO_AGENDAINTMULTI.sql
create or replace TRIGGER MGCLI.T_CLI_GLO_AGENDAINTMULTI
BEFORE INSERT OR UPDATE ON MGGLO.GLO_AGENDAINTMULTI
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
:NEW.AIM_IN_USUARIOINTEGRA := 1;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment