Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. CREATE OR ALTER TRIGGER AU_CONTRACT_EXTRA FOR CONTRACT_EXTRA
  2. ACTIVE AFTER UPDATE POSITION 0
  3. AS
  4. begin
  5. if (((new.EXECUTE_BEGIN <> old.EXECUTE_BEGIN)
  6. or (old.EXECUTE_BEGIN is null))
  7. or ((new.EXECUTE_END <> old.EXECUTE_END)
  8. or (old.EXECUTE_END is null))) then
  9. execute procedure SP_PROPOSAL_ADD_TO_CONTRACT(-1, old.CONTRACT_ID, 2);
  10. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement