| 1 |
object SelectDeptDlg: TSelectDeptDlg
|
| 2 |
Left = 677
|
| 3 |
Height = 449
|
| 4 |
Top = 296
|
| 5 |
Width = 485
|
| 6 |
BorderStyle = bsDialog
|
| 7 |
Caption = 'Select Department'
|
| 8 |
ClientHeight = 449
|
| 9 |
ClientWidth = 485
|
| 10 |
OnClose = FormClose
|
| 11 |
OnShow = FormShow
|
| 12 |
Position = poOwnerFormCenter
|
| 13 |
LCLVersion = '1.8.0.4'
|
| 14 |
object Label1: TLabel
|
| 15 |
Left = 16
|
| 16 |
Height = 14
|
| 17 |
Top = 16
|
| 18 |
Width = 79
|
| 19 |
Caption = 'Departments'
|
| 20 |
ParentColor = False
|
| 21 |
end
|
| 22 |
object DeptsTreeView: TIBTreeView
|
| 23 |
Left = 19
|
| 24 |
Height = 399
|
| 25 |
Top = 37
|
| 26 |
Width = 359
|
| 27 |
TextField = 'DEPARTMENT'
|
| 28 |
DataSource = DataSource1
|
| 29 |
HasChildField = 'CHILDCOUNT'
|
| 30 |
KeyField = 'DEPT_NO'
|
| 31 |
ParentField = 'HEAD_DEPT'
|
| 32 |
ReadOnly = True
|
| 33 |
RelationName = 'A'
|
| 34 |
TabOrder = 0
|
| 35 |
OnDblClick = DeptsTreeViewDblClick
|
| 36 |
Options = [tvoAutoItemHeight, tvoHideSelection, tvoKeepCollapsedNodes, tvoReadOnly, tvoShowButtons, tvoShowLines, tvoShowRoot, tvoToolTips, tvoThemedDraw]
|
| 37 |
end
|
| 38 |
object Button1: TButton
|
| 39 |
Left = 394
|
| 40 |
Height = 30
|
| 41 |
Top = 37
|
| 42 |
Width = 75
|
| 43 |
Caption = 'OK'
|
| 44 |
Default = True
|
| 45 |
ModalResult = 1
|
| 46 |
TabOrder = 1
|
| 47 |
end
|
| 48 |
object Button2: TButton
|
| 49 |
Left = 394
|
| 50 |
Height = 30
|
| 51 |
Top = 72
|
| 52 |
Width = 75
|
| 53 |
Cancel = True
|
| 54 |
Caption = 'Cancel'
|
| 55 |
ModalResult = 2
|
| 56 |
TabOrder = 2
|
| 57 |
end
|
| 58 |
object Depts: TIBQuery
|
| 59 |
AllowAutoActivateTransaction = False
|
| 60 |
Database = Form1.IBDatabase1
|
| 61 |
Transaction = Form1.IBTransaction1
|
| 62 |
BufferChunks = 1000
|
| 63 |
CachedUpdates = False
|
| 64 |
GenerateParamNames = False
|
| 65 |
GeneratorField.ApplyOnEvent = gaeOnNewRecord
|
| 66 |
SQL.Strings = (
|
| 67 |
'Select A.DEPT_NO, A.DEPARTMENT, A.HEAD_DEPT,count(B.DEPT_NO)'
|
| 68 |
'as ChildCount '
|
| 69 |
'From DEPARTMENT A'
|
| 70 |
'Left Outer JOIN DEPARTMENT B '
|
| 71 |
' On B.HEAD_DEPT = A.DEPT_NO'
|
| 72 |
'Group By A.DEPT_NO, A.DEPARTMENT, A.HEAD_DEPT'
|
| 73 |
)
|
| 74 |
Params = <>
|
| 75 |
DataSetCloseAction = dcDiscardChanges
|
| 76 |
left = 432
|
| 77 |
top = 125
|
| 78 |
end
|
| 79 |
object DataSource1: TDataSource
|
| 80 |
DataSet = Depts
|
| 81 |
left = 392
|
| 82 |
top = 125
|
| 83 |
end
|
| 84 |
end
|
