Project

General

Profile

br-dyn-val-expr.p

Stanislav Lomany, 10/11/2017 10:12 AM

Download (1.85 KB)

 
1

    
2
DEFINE VARIABLE name-hdl AS WIDGET-HANDLE.
3
DEFINE VARIABLE num-hdl AS WIDGET-HANDLE.
4
DEFINE VARIABLE address-hdl AS WIDGET-HANDLE.
5
DEFINE VARIABLE col-hdl AS WIDGET-HANDLE.
6
DEFINE VARIABLE calc-col-hdl AS WIDGET-HANDLE.
7
DEFINE VARIABLE buff-field-hdl AS WIDGET-HANDLE.
8
DEFINE VARIABLE brws-col-hdl AS WIDGET-HANDLE.
9
DEFINE VARIABLE j AS INTEGER.
10
def var i as INTEGER.
11
def button btn-create label "create browse".
12
def button btn-delete label "delete browse".
13

    
14
def temp-table tt field f1 as integer
15
                  field f2 as character.
16
                     
17
repeat i = 1 to 20:                     
18
  create tt. tt.f1 = i. tt.f2 = "test " + string(i).
19
end.
20

    
21

    
22
DEFINE FRAME MyFrame btn-create btn-delete WITH SIZE 80 BY 20.
23

    
24
def var query-hdl as handle.
25
def var buf-hdl as handle.
26
def var field-hdl as handle.
27
def var browse-hdl as handle.
28

    
29
def QUERY q for tt scrolling.
30
OPEN QUERY q for each tt.
31

    
32
ENABLE ALL WITH FRAME MyFrame.
33

    
34
on choose of btn-create do:
35
 CREATE BROWSE browse-hdl
36
             ASSIGN TITLE = "Dynamic Browse"
37
             X = 3
38
             Y = 40
39
             WIDTH = 70
40
             HEIGHT = 10
41
             MULTIPLE          = TRUE
42
             FRAME = FRAME MyFrame:HANDLE
43
             SENSITIVE         = TRUE
44
             ROW-MARKERS       = FALSE
45
             HIDDEN            = FALSE
46
             COLUMN-MOVABLE    = TRUE
47
             COLUMN-RESIZABLE  = TRUE
48
             QUERY = query q:handle
49
             READ-ONLY = NO.            
50
             
51
 buffer tt:buffer-field("f2"):validate-expression = "tt.f2 <> 'test 5'".
52
 buffer tt:buffer-field("f2"):validate-message = "the message".
53
              
54
 col-hdl = browse-hdl:ADD-LIKE-COLUMN("tt.f1").
55
 col-hdl:READ-ONLY = FALSE.
56
 col-hdl = browse-hdl:ADD-LIKE-COLUMN("tt.f2").
57
 col-hdl:READ-ONLY = FALSE.
58
 
59
 
60
end.
61

    
62
on choose of btn-delete do:
63
 DELETE WIDGET browse-hdl.
64
end.
65

    
66
WAIT-FOR CLOSE OF CURRENT-WINDOW.