Project

General

Profile

presortquery.p

Dănuț Filimon, 06/14/2023 04:51 AM

Download (2.47 KB)

 
1
DEFINE TEMP-TABLE tt1
2
    FIELD f1 AS INTEGER
3
    FIELD f2 AS INTEGER
4
    FIELD f3 AS INTEGER.
5
    
6
DEFINE VARIABLE iIter AS INTEGER NO-UNDO.
7

    
8
DO iIter = 0 TO 15.
9
    CREATE tt1.
10
    tt1.f1 = iIter MODULO 5.
11
    tt1.f2 = iIter MODULO 3.
12
    tt1.f3 = iIter MODULO 7.
13
END.
14

    
15
MESSAGE "tt1============================".
16
    
17
FOR EACH tt1 BREAK BY tt1.f1.
18
    MESSAGE tt1.f1 tt1.f2 tt1.f3.
19
END.
20

    
21
MESSAGE "tt1============================".
22

    
23
FOR EACH tt1 BREAK BY tt1.f2.
24
    MESSAGE tt1.f1 tt1.f2 tt1.f3.
25
END.
26

    
27
MESSAGE "tt1============================".
28

    
29
FOR EACH tt1 BREAK BY tt1.f3.
30
    MESSAGE tt1.f1 tt1.f2 tt1.f3.
31
END.
32

    
33
DEFINE TEMP-TABLE tt2
34
    FIELD f1 AS INTEGER
35
    FIELD f2 AS INTEGER
36
    FIELD f3 AS INTEGER
37
    INDEX idx1 f1.
38
    
39
DO iIter = 0 TO 15.
40
    CREATE tt2.
41
    tt2.f1 = iIter MODULO 5.
42
    tt2.f2 = iIter MODULO 3.
43
    tt2.f3 = iIter MODULO 7.
44
END.
45

    
46
MESSAGE "tt2============================".
47
    
48
FOR EACH tt2 BREAK BY tt2.f1.
49
    MESSAGE tt2.f1 tt2.f2 tt2.f3.
50
END.
51

    
52
MESSAGE "tt2============================".
53

    
54
FOR EACH tt2 BREAK BY tt2.f2.
55
    MESSAGE tt2.f1 tt2.f2 tt2.f3.
56
END.
57

    
58
MESSAGE "tt2============================".
59

    
60
FOR EACH tt2 BREAK BY tt2.f3.
61
    MESSAGE tt2.f1 tt2.f2 tt2.f3.
62
END.
63

    
64
DEFINE TEMP-TABLE tt3
65
    FIELD f1 AS INTEGER
66
    FIELD f2 AS INTEGER
67
    FIELD f3 AS INTEGER
68
    INDEX idx1 f1 f2.
69
    
70
DO iIter = 0 TO 15.
71
    CREATE tt3.
72
    tt3.f1 = iIter MODULO 5.
73
    tt3.f2 = iIter MODULO 3.
74
    tt3.f3 = iIter MODULO 7.
75
END.
76

    
77
MESSAGE "tt3============================".
78
    
79
FOR EACH tt3 BREAK BY tt3.f1.
80
    MESSAGE tt3.f1 tt3.f2 tt3.f3.
81
END.
82

    
83
MESSAGE "tt3============================".
84

    
85
FOR EACH tt3 BREAK BY tt3.f2.
86
    MESSAGE tt3.f1 tt3.f2 tt3.f3.
87
END.
88

    
89
MESSAGE "tt3============================".
90

    
91
FOR EACH tt3 BREAK BY tt3.f3.
92
    MESSAGE tt3.f1 tt3.f2 tt3.f3.
93
END.
94

    
95
DEFINE TEMP-TABLE tt4
96
    FIELD f1 AS INTEGER
97
    FIELD f2 AS INTEGER
98
    FIELD f3 AS INTEGER
99
    INDEX idx1 f1 f2 f3.
100
    
101
DO iIter = 0 TO 15.
102
    CREATE tt4.
103
    tt4.f1 = iIter MODULO 5.
104
    tt4.f2 = iIter MODULO 3.
105
    tt4.f3 = iIter MODULO 7.
106
END.
107

    
108
MESSAGE "tt4============================".
109
    
110
FOR EACH tt4 BREAK BY tt4.f1.
111
    MESSAGE tt4.f1 tt4.f2 tt4.f3.
112
END.
113

    
114
MESSAGE "tt4============================".
115

    
116
FOR EACH tt4 BREAK BY tt4.f2.
117
    MESSAGE tt4.f1 tt4.f2 tt4.f3.
118
END.
119

    
120
MESSAGE "tt4============================".
121

    
122
FOR EACH tt4 BREAK BY tt4.f3.
123
    MESSAGE tt4.f1 tt4.f2 tt4.f3.
124
END.