fields-except.p
1 |
def temp-table tt |
---|---|
2 |
field f1 as integer |
3 |
field f2 as integer |
4 |
field f3 as integer extent 3. |
5 |
|
6 |
CREATE tt. |
7 |
|
8 |
def temp-table tt2 |
9 |
field f4 as integer |
10 |
field f5 as integer |
11 |
field f6 as integer extent 3. |
12 |
|
13 |
CREATE tt2. |
14 |
|
15 |
|
16 |
for each tt fields(f1 f2): |
17 |
message "test1". |
18 |
end. |
19 |
|
20 |
for first tt fields(f1 f2): |
21 |
message "test2". |
22 |
end. |
23 |
|
24 |
for first tt fields(f1 f2), |
25 |
first tt2 fields(f4 f5): |
26 |
message "test3". |
27 |
end. |
28 |
|
29 |
for first tt fields(f1 f2), |
30 |
each tt2 fields(f4 f5): |
31 |
message "test4". |
32 |
end. |
33 |
|
34 |
|
35 |
for each tt fields(f1): |
36 |
message "test11". |
37 |
end. |
38 |
|
39 |
for each tt fields(): |
40 |
message "test12". |
41 |
end. |
42 |
|
43 |
for each tt fields: |
44 |
message "test13". |
45 |
end. |
46 |
|
47 |
for each tt fields(f1 f1): |
48 |
message "test14". |
49 |
end. |
50 |
|
51 |
for each tt fields(f3): |
52 |
message "test15". |
53 |
end. |
54 |
|
55 |
for each tt fields(f3[1]): |
56 |
message "test16". |
57 |
end. |
58 |
|
59 |
for each tt fields(f3[1] f3[2]): |
60 |
message "test17". |
61 |
end. |
62 |
|
63 |
|
64 |
for each tt except(f1): |
65 |
message "test21". |
66 |
end. |
67 |
|
68 |
for each tt except(): |
69 |
message "test22". |
70 |
end. |
71 |
|
72 |
for each tt except: |
73 |
message "test23". |
74 |
end. |
75 |
|
76 |
for each tt except(f1 f1): |
77 |
message "test24". |
78 |
end. |
79 |
|
80 |
for each tt except(f3): |
81 |
message "test25". |
82 |
end. |
83 |
|
84 |
for each tt except(f3[1]): |
85 |
message "test26". |
86 |
end. |
87 |
|
88 |
for each tt except(f3[1] f3[2]): |
89 |
message "test27". |
90 |
end. |
91 |
|
92 |
|
93 |
|
94 |
for each tt fields(f1), |
95 |
tt2 fields(f4): |
96 |
message "test31". |
97 |
end. |
98 |
|
99 |
for each tt fields(), |
100 |
tt2 fields(): |
101 |
message "test32". |
102 |
end. |
103 |
|
104 |
for each tt fields, |
105 |
tt2 fields: |
106 |
message "test33". |
107 |
end. |
108 |
|
109 |
for each tt fields(f1 f1), |
110 |
tt2 fields(f4 f4): |
111 |
message "test34". |
112 |
end. |
113 |
|
114 |
for each tt fields(f3), |
115 |
tt2 fields(f6): |
116 |
message "test35". |
117 |
end. |
118 |
|
119 |
for each tt fields(f3[1]), |
120 |
tt2 fields(f6[1]): |
121 |
message "test36". |
122 |
end. |
123 |
|
124 |
for each tt fields(f3[1] f3[2]), |
125 |
tt2 fields(f6[1] f6[2]): |
126 |
message "test37". |
127 |
end. |
128 |
|
129 |
|
130 |
|
131 |
for each tt except(f1), |
132 |
tt2 except(f4): |
133 |
message "test41". |
134 |
end. |
135 |
|
136 |
for each tt except(), |
137 |
tt2 except(): |
138 |
message "test42". |
139 |
end. |
140 |
|
141 |
for each tt except, |
142 |
tt2 except: |
143 |
message "test43". |
144 |
end. |
145 |
|
146 |
for each tt except(f1 f1), |
147 |
tt2 except(f4 f4): |
148 |
message "test44". |
149 |
end. |
150 |
|
151 |
for each tt except(f3), |
152 |
tt2 except(f6): |
153 |
message "test45". |
154 |
end. |
155 |
|
156 |
for each tt except(f3[1]), |
157 |
tt2 except(f6[1]): |
158 |
message "test46". |
159 |
end. |
160 |
|
161 |
for each tt except(f3[1] f3[2]), |
162 |
tt2 except(f6[1] f6[2]): |
163 |
message "test47". |
164 |
end. |