-
Notifications
You must be signed in to change notification settings - Fork 3
/
Q_UserRole_List_Search.def
144 lines (144 loc) · 8.71 KB
/
Q_UserRole_List_Search.def
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
Operation =1
Option =0
Where ="(((UserRoles.Code) Like \"*\" & Forms!UserRole_List!txtSearch & \"*\")) Or (((Us"
"erRoles.Name) Like \"*\" & Forms!UserRole_List!txtSearch & \"*\")) Or (((UserRol"
"es.Description) Like \"*\" & Forms!UserRole_List!txtSearch & \"*\")) Or (((UserR"
"oles.Memo) Like \"*\" & Forms!UserRole_List!txtSearch & \"*\"))"
Begin InputTables
Name ="UserRoles"
End
Begin OutputColumns
Expression ="UserRoles.Id"
Expression ="UserRoles.Code"
Expression ="UserRoles.Name"
Expression ="UserRoles.Description"
Expression ="UserRoles.Sort"
Expression ="UserRoles.Active"
Expression ="UserRoles.Memo"
End
Begin OrderBy
Expression ="UserRoles.Name"
Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="0"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbBoolean "TotalsRow" ="0"
dbByte "PublishToWeb" ="1"
dbLongBinary "DOL" = Begin
0x0acc0e55000000001af27797e9a03540a971d23f56fc2d1d00000000b84f2bb3 ,
0x1d36e5400000000000000000550073006500720052006f006c00650073000000 ,
0x000000009e20aa33e5f90d4cb6048d217a9a8609070000001af27797e9a03540 ,
0xa971d23f56fc2d1d49006400000000000000e06c72f378431d4399a9dd23254d ,
0x6bc2070000001af27797e9a03540a971d23f56fc2d1d43006f00640065000000 ,
0x00000000bd512bc63e69d3468c96b920c6ada0e1070000001af27797e9a03540 ,
0xa971d23f56fc2d1d4e0061006d0065000000000000002fa7e73e7b053d47b8c6 ,
0x67aa999ea19f070000001af27797e9a03540a971d23f56fc2d1d440065007300 ,
0x6300720069007000740069006f006e000000000000008c658a6cb9109d4f8fea ,
0x3a57a7a89b77070000001af27797e9a03540a971d23f56fc2d1d53006f007200 ,
0x7400000000000000f255cdd648a833409447e8f8e53fc860070000001af27797 ,
0xe9a03540a971d23f56fc2d1d410063007400690076006500000000000000147d ,
0x95655cf9c24582a357ec22015f8b070000001af27797e9a03540a971d23f56fc ,
0x2d1d4d0065006d006f00000000000000f18c7bc3adbf944191241c3e1998f9ef ,
0x01000000721e62d31d36e5400000000000000000550073006500720052006f00 ,
0x6c0065005f004c006900730074000000000000005856f935af6d484ebe43ffd8 ,
0xcf78f5cd06000000f18c7bc3adbf944191241c3e1998f9ef7400780074005300 ,
0x6500610072006300680000000000000000000000000000000000000000000000 ,
0x0c000000050000000000000000000000000000000000
End
dbBinary "GUID" = Begin
0xf27450e90f03674e8a4a81fc087622f6
End
Begin
Begin
dbText "Name" ="Users.Code"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="Users.Id"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="Users.Name"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="Users.Description"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="Users.Sort"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="Users.Active"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="Users.Memo"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="UserRoles.Name"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="UserRoleName"
dbLong "AggregateType" ="-1"
dbBinary "GUID" = Begin
0xe9650d431997d049b54a448f432af69f
End
End
Begin
dbText "Name" ="UserRoles.Id"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="UserRoles.Code"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="UserRoles.Description"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="UserRoles.Sort"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="UserRoles.Active"
dbLong "AggregateType" ="-1"
End
Begin
dbText "Name" ="UserRoles.Memo"
dbLong "AggregateType" ="-1"
End
End
Begin
State =0
Left =0
Top =0
Right =3403
Bottom =1624
Left =-1
Top =-1
Right =3370
Bottom =249
Left =0
Top =0
ColumnsShown =539
Begin
Left =480
Top =24
Right =768
Bottom =312
Top =0
Name ="UserRoles"
Name =""
End
End