| 1 |
tony |
23 |
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 |
