| 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 = poMainFormCenter |
| 13 |
LCLVersion = '1.8.1.0' |
| 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 |
