1
|
define variable htt1 as handle.
|
2
|
define variable htt2 as handle.
|
3
|
|
4
|
create temp-table htt1.
|
5
|
htt1:add-new-field("f1", "char").
|
6
|
htt1:add-new-field("f2", "char").
|
7
|
htt1:add-new-field("f3", "char").
|
8
|
htt1:add-new-index("idx1", true).
|
9
|
htt1:ADD-INDEX-FIELD("idx1", "f1").
|
10
|
htt1:temp-table-prepare('tt1').
|
11
|
|
12
|
htt1:default-buffer-handle:buffer-create().
|
13
|
htt1:default-buffer-handle::f1 = "abc1".
|
14
|
htt1:default-buffer-handle::f2 = "abc1".
|
15
|
htt1:default-buffer-handle::f3 = "abc1".
|
16
|
htt1:default-buffer-handle:buffer-release().
|
17
|
|
18
|
htt1:default-buffer-handle:buffer-create().
|
19
|
htt1:default-buffer-handle::f1 = "abc2".
|
20
|
htt1:default-buffer-handle::f2 = "abc2".
|
21
|
htt1:default-buffer-handle::f3 = "abc2".
|
22
|
htt1:default-buffer-handle:buffer-release().
|
23
|
|
24
|
htt1:default-buffer-handle:buffer-create().
|
25
|
htt1:default-buffer-handle::f1 = "abc3".
|
26
|
htt1:default-buffer-handle::f2 = "abc3".
|
27
|
htt1:default-buffer-handle::f3 = "abc3".
|
28
|
htt1:default-buffer-handle:buffer-release().
|
29
|
|
30
|
create temp-table htt2.
|
31
|
htt2:add-new-field("f3", "char").
|
32
|
htt2:add-new-field("f2", "char").
|
33
|
htt2:add-new-field("f1", "char").
|
34
|
htt2:add-new-index("idx1", true).
|
35
|
htt2:ADD-INDEX-FIELD("idx1", "f2"). // no matter the field, this will work
|
36
|
htt2:temp-table-prepare('tt2').
|
37
|
|
38
|
htt2:COPY-TEMP-TABLE(htt1).
|