📄 suncms.dm1.svn-base
字号:
'Emit the trigger code for each parent relationship for this table
Dim Rel As Relationship
Dim Action As String
For Each Rel In CurrEntity.ChildRelationships
Action = Rel.ChildAction(""INSERT"")
If Action = ""RESTRICT"" Then
Result = Result & OraDefChInsRstr(Rel, TriggerName)
End If
Next Rel
'Standard trigger body end for insert action
Result = Result & vbCrLf & ""END;"" & vbCrLf
'Display result in message box (remove ' from line below)
'MsgBox(Result)
'Assign result SQL to external string for execution
ResultString = Result
End Sub
",0
StringUsage
StringUsage_Id,UniqueObject_Id,StringUsageType_Id,String_Id,Row_Time_Stamp
1,2,99,6,0
2,2,100,2,0
3,3,37,3,0
4,21,38,4,0
5,95,112,5,0
6,95,113,5,0
7,1,58,7,0
8,1,51,7,0
9,1,52,8,0
10,1,53,9,0
11,1,54,10,0
12,1,55,9,0
13,1,57,11,0
14,106,1,14,0
15,106,2,128,0
16,111,14,16,0
17,113,14,17,0
18,116,14,18,0
19,116,15,87,0
20,117,14,19,0
21,117,15,88,0
22,118,14,20,0
23,118,15,89,0
24,119,14,21,0
25,119,15,76,0
26,120,14,22,0
27,120,15,77,0
28,121,14,23,0
29,121,15,78,0
596,1054,63,132,0
30,122,14,24,0
597,1054,14,133,0
31,122,15,79,0
598,1054,15,134,0
32,123,1,26,0
33,123,2,125,0
600,1055,1,135,0
34,128,14,27,0
601,1055,2,137,0
35,130,14,28,0
602,1060,14,136,0
36,131,14,29,0
37,132,14,30,0
38,133,14,31,0
605,1060,15,68,0
39,134,14,32,0
606,1068,14,138,0
40,135,14,21,0
607,1068,15,139,0
41,136,14,22,0
42,137,14,23,0
608,1069,14,140,0
43,138,14,24,0
609,1069,15,141,0
44,139,1,34,0
610,1070,14,142,0
45,139,2,127,0
611,1070,15,143,0
46,144,14,35,0
612,1071,14,144,0
47,148,14,36,0
613,1071,15,145,0
48,149,14,37,0
614,1072,14,147,0
49,150,14,21,0
615,1072,15,148,0
50,151,14,22,0
616,1073,14,149,0
51,152,14,23,0
617,1073,15,150,0
52,153,14,24,0
618,1074,14,152,0
53,108,39,38,0
619,1074,15,153,0
54,125,39,39,0
620,1075,14,154,0
55,141,39,40,0
621,1075,15,155,0
622,1076,14,156,0
623,1076,15,157,0
624,1077,63,72,0
625,1077,14,159,0
626,1077,15,160,0
627,1078,14,161,0
628,1078,15,162,0
63,165,1,49,0
629,1079,14,21,0
64,165,2,129,0
630,1079,15,76,0
631,1080,14,22,0
632,1080,15,77,0
633,1081,14,23,0
634,1081,15,164,0
635,1082,14,24,0
636,1082,15,165,0
637,1083,14,166,0
638,1083,15,167,0
639,1084,14,168,0
74,185,14,43,0
640,1084,15,169,0
75,185,15,68,0
641,1057,39,170,0
643,1103,38,4,0
86,194,1,42,0
87,194,2,126,0
88,199,14,44,0
89,201,14,56,0
90,202,14,46,0
91,205,15,90,0
92,205,14,44,0
93,205,11,90,0
95,209,15,91,0
96,209,14,27,0
97,209,11,91,0
99,167,39,59,0
100,196,39,60,0
101,211,1,62,0
102,211,2,130,0
103,216,14,43,0
104,220,15,90,0
105,220,14,44,0
955,1744,1,188,0
106,220,11,90,0
956,1744,2,192,0
957,1749,14,43,0
108,224,15,92,0
958,1751,14,35,0
109,224,14,35,0
959,1752,14,172,0
110,224,11,92,0
960,1753,14,189,0
961,1754,14,190,0
112,226,1,64,0
962,1755,14,191,0
113,226,2,131,0
963,1749,15,68,0
114,231,14,43,0
964,1751,15,193,0
115,235,15,93,0
965,1752,15,194,0
116,235,14,16,0
966,1753,15,195,0
117,235,11,93,0
967,1754,15,178,0
968,1755,15,196,0
119,239,15,90,0
969,1746,39,197,0
120,239,14,44,0
970,1757,37,198,0
121,239,11,90,0
971,1775,38,4,0
972,1849,1,188,0
123,213,39,65,0
973,1849,2,192,0
124,228,39,66,0
974,1851,15,68,0
975,1851,14,43,0
126,128,15,68,0
976,1852,15,193,0
127,130,15,70,0
977,1852,14,35,0
128,133,15,71,0
978,1853,15,194,0
129,131,63,72,0
979,1853,14,172,0
130,131,15,73,0
980,1854,15,195,0
131,132,15,74,0
981,1854,14,189,0
132,134,15,75,0
982,1855,15,178,0
133,135,15,76,0
983,1855,14,190,0
134,136,15,77,0
984,1856,15,196,0
135,137,15,78,0
985,1856,14,191,0
136,138,15,79,0
986,1857,39,197,0
137,199,15,68,0
138,201,15,80,0
139,202,15,81,0
140,241,14,82,0
141,241,15,83,0
142,144,15,68,0
143,148,15,84,0
144,149,15,85,0
145,150,15,76,0
146,151,15,77,0
147,152,15,78,0
148,153,15,79,0
149,111,15,68,0
150,113,15,86,0
486,117,63,72,0
488,873,38,4,0
794,1309,1,171,0
795,1309,2,176,0
796,1314,14,172,0
797,1316,14,173,0
798,1317,14,174,0
800,1314,15,68,0
801,1316,15,177,0
802,1317,15,178,0
805,1337,38,4,0
817,1311,39,182,0
818,1429,14,175,0
819,1429,15,180,0
820,1430,14,183,0
821,1430,15,184,0
822,1431,14,185,0
823,1431,15,186,0
258,451,92,101,0
259,451,94,102,0
825,1450,38,4,0
260,452,92,103,0
261,452,94,104,0
262,453,92,105,0
263,453,94,106,0
264,454,89,107,0
265,454,91,108,0
266,455,89,109,0
267,455,91,110,0
268,456,89,111,0
269,456,91,112,0
841,231,15,43,0
842,216,15,43,0
844,1562,38,4,0
StringUsageType
StringUsageType_Id,UsageName,Description,Global_User_ID,Row_Time_Stamp
1,Entity Name,"",0,0
2,Table Name,"",0,0
3,Entity Definition,"",0,0
4,Entity Note,"",0,0
5,Entity Owner,"",0,0
6,Display Label Singular,"",0,0
7,Display Label Plural,"",0,0
8,Row Value Expression,"",0,0
9,Entity Type,"",0,0
10,Unique Rolename,"",0,0
11,Rolename,"",0,0
12,Attribute Note,"",0,0
13,Attribute Definition,"",0,0
14,Attribute Name,"",0,0
15,Column Name,"",0,0
16,Full Rolename,"",0,0
17,Unique Column Name,"",0,0
18,Relationship Name,"",0,0
19,Verb Phrase,"",0,0
20,Inverse Phrase,"",0,0
21,Relationship Definition,"",0,0
22,Relationship Note,"",0,0
23,Relationship Type,"",0,0
24,Parent Constraint Type,"",0,0
25,Parent Cardinality,"",0,0
26,Child Cardinality,"",0,0
27,Parent Optionality,"",0,0
28,Child Optionality,"",0,0
29,Parent Insert,"",0,0
30,Parent Update,"",0,0
31,Parent Delete,"",0,0
32,Child Insert,"",0,0
33,Child Update,"",0,0
34,Child Delete,"",0,0
35,Insert Child Form Type,"",0,0
36,Update Child Form Type,"",0,0
37,Model Name,"",0,0
38,View Model Name,"",0,0
39,Index Name,"",0,0
40,Index Default Name,"",0,0
41,Is Unique,"",0,0
42,Index Type,"",0,0
43,Key Type,"",0,0
44,Hash Size Type,"",0,0
45,Ignore Duplicate Key,"",0,0
46,Duplicate Row,"",0,0
47,No Sort,"",0,0
48,Sort Ordering,"",0,0
49,Domain Name,"",0,0
50,Domain Column Name,"",0,0
51,Diagram Name,"",0,0
52,Author,"",0,0
53,Company,"",0,0
54,Version No,"",0,0
55,Copyright,"",0,0
56,Diagram Definition,"",0,0
57,Unification Option,"",0,0
58,File Name,"",0,0
59,Check Constraint Name,"",0,0
60,Check Constraint Text,"",0,0
61,User Data Type,"",0,0
62,Data Type Id,"",0,0
63,Default,"",0,0
64,Rule,"",0,0
65,Default Name,"",0,0
66,Rule Name,"",0,0
67,Default Base Name,"",0,0
68,Default Base Text,"",0,0
69,Rule Base Name,"",0,0
70,Rule Base Text,"",0,0
71,Copyright Year,"",0,0
72,View Definition,"",0,0
73,View Name,"",0,0
74,View Note,"",0,0
75,View Owner,"",0,0
76,DbTrigger Name,"",0,0
77,DbTrigger Owner,"",0,0
78,DbTrigger Description,"",0,0
79,DbTrigger Value,"",0,0
80,Proc Name,"",0,0
81,Proc Owner,"",0,0
82,Proc Description,"",0,0
83,Proc Value,"",0,0
84,DbPackage Name,"",0,0
85,DbPackage Owner,"",0,0
86,DbPackage Description,"",0,0
87,DbPackage Header Value,"",0,0
88,DbPackage Body Value,"",0,0
89,Dictionary Trigger Name,"",0,0
90,Dictionary Trigger Description,"",0,0
91,Dictionary Trigger Value,"",0,0
92,Dictionary Library Name,"",0,0
93,Dictionary Library Description,"",0,0
94,Dictionary Library Value,"",0,0
95,Logical Rolename,"",0,0
96,Reusable Procedure Name,"",0,0
97,Reusable Procedure Description,"",0,0
98,Reusable Procedure Value,"",0,0
99,Data Dictionary Name,"",0,0
100,Data Dictionary Descrip
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -