Wiki source code of Команды отключения триггеров работы над дизайнами только в 4-й для редакции дизайна в 5 версии
Last modified by Nefedenkova Viktoria on 2021/09/28 14:25
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | ===== Команды отключения триггеров работы над дизайнами только в 4-й для редакции дизайна в 5 версии: ===== | ||
| 2 | |||
| 3 | alter trigger A$LOB$TR disable | ||
| 4 | \\alter trigger A$LOB$TR_BL5 enable | ||
| 5 | |||
| 6 | |||
| 7 | ~-~-~-~-- триггер включающий блокировку: | ||
| 8 | |||
| 9 | |||
| 10 | (% class="MsoNormal" %) | ||
| 11 | (% lang="EN-US" style="mso-ansi-language:EN-US" %)CREATE OR REPLACE TRIGGER (% lang="EN-US" style="mso-ansi-language: EN-US; font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: red; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU" %) (% lang="EN-US" style="mso-ansi-language: EN-US; font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: red; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU; font-size: 12pt; line-height: 115%; font-family: Courier; mso-fareast-font-family: Calibri; mso-bidi-font-family: Courier; color: red; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA" %)//**A$LOB$TR_BL5**//(% lang="EN-US" style="mso-ansi-language: EN-US; font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: red; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU; font-size: 12pt; line-height: 115%; font-family: Courier; mso-fareast-font-family: Calibri; mso-bidi-font-family: Courier; color: red; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; font-size: 10pt; line-height: 115%; font-family: Courier; mso-fareast-font-family: Calibri; mso-bidi-font-family: Courier; color: black; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA" %)//** **//(% lang="EN-US" style="mso-ansi-language: EN-US; font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: red; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU" %) | ||
| 12 | |||
| 13 | (% class="MsoNormal" %) | ||
| 14 | (% lang="EN-US" style="mso-ansi-language:EN-US" %)before insert or update ON A$LOB | ||
| 15 | |||
| 16 | (% class="MsoNormal" %) | ||
| 17 | (% lang="EN-US" style="mso-ansi-language:EN-US" %)for each row | ||
| 18 | |||
| 19 | (% class="MsoNormal" %) | ||
| 20 | (% lang="EN-US" style="mso-ansi-language:EN-US" %)begin | ||
| 21 | |||
| 22 | (% class="MsoNormal" %) | ||
| 23 | (% lang="EN-US" style="mso-ansi-language:EN-US" %) (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)if lower(:new.lob_name) like lower('%template%') then(% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)null; | ||
| 24 | |||
| 25 | (% class="MsoNormal" %) | ||
| 26 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)else | ||
| 27 | |||
| 28 | (% class="MsoNormal" %) | ||
| 29 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)if substr(sys_context('userenv','CLIENT_INFO'),1,1) >4(% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)and | ||
| 30 | |||
| 31 | (% class="MsoNormal" %) | ||
| 32 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %):new.lob_type != 5(% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) | ||
| 33 | |||
| 34 | (% class="MsoNormal" %) | ||
| 35 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)then msg('TEMPORAR salvare dizain doar in versiune 4....'); | ||
| 36 | |||
| 37 | (% class="MsoNormal" %) | ||
| 38 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)end if; | ||
| 39 | |||
| 40 | (% class="MsoNormal" %) | ||
| 41 | (% lang="EN-US" style="mso-ansi-language:EN-US" %)end if; | ||
| 42 | |||
| 43 | (% class="MsoNormal" %) | ||
| 44 | (% lang="EN-US" style="mso-ansi-language:EN-US" %) (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)if(% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %):new.lob_type in (5,6) then return;(% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)end if;(% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) | ||
| 45 | |||
| 46 | (% class="MsoNormal" %) | ||
| 47 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)if updating or :new.time_stamp is null then | ||
| 48 | |||
| 49 | (% class="MsoNormal" %) | ||
| 50 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %):new.time_stamp:=sysdate; | ||
| 51 | |||
| 52 | (% class="MsoNormal" %) | ||
| 53 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)end if; | ||
| 54 | |||
| 55 | (% class="MsoNormal" %) | ||
| 56 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (% lang="EN-US" style="mso-ansi-language:EN-US" %)~-~- un$process_log.log('4',act ||' ;new='||:new.obj_id||'; old= '||:old.obj_id); | ||
| 57 | |||
| 58 | (% class="MsoNormal" style="border:none;mso-border-bottom-alt:solid windowtext .75pt; padding:0cm;mso-padding-alt:0cm 0cm 1.0pt 0cm" %) | ||
| 59 | (% lang="EN-US" style="mso-ansi-language: EN-US; mso-spacerun: yes" %) (%%)end; | ||
| 60 | |||
| 61 | (% style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .75pt;padding:0cm 0cm 1.0pt 0cm" %) | ||
| 62 | ((( | ||
| 63 | |||
| 64 | ))) | ||
| 65 | |||
| 66 | (% class="MsoNormal" %) | ||
| 67 | без блокровки: | ||
| 68 | |||
| 69 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 70 | (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family:Courier; color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)CREATE(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)OR(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)REPLACE(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)TRIGGER(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:red;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %)A$LOB$TR(% lang="EN-US" style="font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: black; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU; mso-spacerun: yes" %) | ||
| 71 | |||
| 72 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 73 | (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family:Courier; color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)before(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)insert(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)or(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)update(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)on(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:olive;background:white;mso-highlight:white;mso-ansi-language: EN-US;mso-fareast-language:RU" %)a$lob | ||
| 74 | |||
| 75 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 76 | (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family:Courier; color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)for(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)each(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)row | ||
| 77 | |||
| 78 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 79 | (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family:Courier; color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)begin | ||
| 80 | |||
| 81 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 82 | (% lang="EN-US" style="font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: black; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU; mso-spacerun: yes" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)if(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)updating(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)or(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %):new.(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %)time_stamp (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)is(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)null(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)then | ||
| 83 | |||
| 84 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 85 | (% lang="EN-US" style="font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: black; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU; mso-spacerun: yes" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %):new.(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %)time_stamp(% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %):=sysdate; | ||
| 86 | |||
| 87 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 88 | (% lang="EN-US" style="font-size: 10pt; font-family: Courier; mso-bidi-font-family: Courier; color: black; background: white; mso-highlight: white; mso-ansi-language: EN-US; mso-fareast-language: RU; mso-spacerun: yes" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)end(% lang="EN-US" style="font-size:10.0pt; font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %) (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family: Courier;color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)if; | ||
| 89 | |||
| 90 | (% class="MsoNormal" style="margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;mso-layout-grid-align:none;text-autospace:none" %) | ||
| 91 | (% lang="EN-US" style="font-size:10.0pt;font-family:Courier;mso-bidi-font-family:Courier; color:blue;background:white;mso-highlight:white;mso-ansi-language:EN-US; mso-fareast-language:RU" %)end; | ||
| 92 | |||
| 93 | (% class="MsoNormal" %) | ||
| 94 | (% lang="EN-US" style="font-size:10.0pt;line-height:115%; font-family:Courier;mso-bidi-font-family:Courier;color:blue;background:white; mso-highlight:white;mso-ansi-language:EN-US;mso-fareast-language:RU" %)/ |