1 |
object EditJobCode: TEditJobCode |
2 |
Left = 512 |
3 |
Height = 104 |
4 |
Top = 364 |
5 |
Width = 330 |
6 |
BorderStyle = bsDialog |
7 |
Caption = 'Edit Job Title' |
8 |
ClientHeight = 104 |
9 |
ClientWidth = 330 |
10 |
OnClose = FormClose |
11 |
OnShow = FormShow |
12 |
Position = poMainFormCenter |
13 |
LCLVersion = '1.4.0.2' |
14 |
object Bevel1: TBevel |
15 |
Left = 8 |
16 |
Height = 70 |
17 |
Top = 11 |
18 |
Width = 227 |
19 |
end |
20 |
object Button1: TButton |
21 |
Left = 245 |
22 |
Height = 25 |
23 |
Top = 8 |
24 |
Width = 75 |
25 |
Caption = 'OK' |
26 |
Default = True |
27 |
ModalResult = 1 |
28 |
TabOrder = 0 |
29 |
end |
30 |
object Button2: TButton |
31 |
Left = 245 |
32 |
Height = 25 |
33 |
Top = 40 |
34 |
Width = 75 |
35 |
Cancel = True |
36 |
Caption = 'Cancel' |
37 |
ModalResult = 2 |
38 |
TabOrder = 1 |
39 |
end |
40 |
object IBLookupComboEditBox1: TIBLookupComboEditBox |
41 |
Left = 16 |
42 |
Height = 25 |
43 |
Top = 24 |
44 |
Width = 203 |
45 |
Anchors = [akTop, akLeft, akRight] |
46 |
AutoSize = False |
47 |
KeyField = 'JOB_CODE' |
48 |
ListField = 'JOB_TITLE' |
49 |
ListFieldIndex = 0 |
50 |
ListSource = JobCodeSource |
51 |
LookupCache = False |
52 |
Style = csDropDownList |
53 |
TabOrder = 2 |
54 |
AutoInsert = False |
55 |
AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending] |
56 |
ItemHeight = 0 |
57 |
end |
58 |
object JobCodes: TIBQuery |
59 |
Database = Form1.IBDatabase1 |
60 |
Transaction = Form1.IBTransaction1 |
61 |
AfterOpen = JobCodesAfterOpen |
62 |
BeforeOpen = JobCodesBeforeOpen |
63 |
BufferChunks = 1000 |
64 |
CachedUpdates = False |
65 |
GenerateParamNames = False |
66 |
GeneratorField.ApplyOnEvent = gaeOnNewRecord |
67 |
SQL.Strings = ( |
68 |
'Select distinct A.JOB_CODE, A.JOB_TITLE From JOB A' |
69 |
'Where JOB_COUNTRY = :JOB_COUNTRY and JOB_GRADE = :JOB_GRADE' |
70 |
'Order by Upper(JOB_TITLE)' |
71 |
) |
72 |
Params = < |
73 |
item |
74 |
DataType = ftUnknown |
75 |
Name = 'JOB_COUNTRY' |
76 |
ParamType = ptInput |
77 |
end |
78 |
item |
79 |
DataType = ftUnknown |
80 |
Name = 'JOB_GRADE' |
81 |
ParamType = ptInput |
82 |
end> |
83 |
left = 280 |
84 |
top = 72 |
85 |
ParamData = < |
86 |
item |
87 |
DataType = ftUnknown |
88 |
Name = 'JOB_COUNTRY' |
89 |
ParamType = ptInput |
90 |
end |
91 |
item |
92 |
DataType = ftUnknown |
93 |
Name = 'JOB_GRADE' |
94 |
ParamType = ptInput |
95 |
end> |
96 |
end |
97 |
object JobCodeSource: TDataSource |
98 |
DataSet = JobCodes |
99 |
left = 256 |
100 |
top = 72 |
101 |
end |
102 |
end |