1 |
|
object Form1: TForm1 |
2 |
< |
Left = 552 |
2 |
> |
Left = 489 |
3 |
|
Height = 438 |
4 |
< |
Top = 437 |
4 |
> |
Top = 219 |
5 |
|
Width = 722 |
6 |
|
Caption = 'TIBTreeView Example' |
7 |
|
ClientHeight = 438 |
10 |
|
OnClose = FormClose |
11 |
|
OnShow = FormShow |
12 |
|
Position = poScreenCenter |
13 |
< |
LCLVersion = '1.8.0.4' |
13 |
> |
LCLVersion = '2.0.11.0' |
14 |
|
object Panel1: TPanel |
15 |
|
Left = 11 |
16 |
|
Height = 367 |
32 |
|
DragMode = dmAutomatic |
33 |
|
Images = ImageList1 |
34 |
|
HasChildField = 'CHILDCOUNT' |
35 |
+ |
ImageIndexField = 'IMAGEINDEX' |
36 |
+ |
SelectedIndexField = 'IMAGEINDEX' |
37 |
|
KeyField = 'DEPT_NO' |
38 |
|
ParentField = 'HEAD_DEPT' |
39 |
|
PopupMenu = PopupMenu1 |
40 |
|
RelationName = 'A' |
41 |
|
ScrollBars = ssAutoBoth |
42 |
|
TabOrder = 0 |
41 |
– |
OnAddition = IBTreeView1Addition |
43 |
|
OnDragDrop = IBTreeView1DragDrop |
44 |
|
OnDragOver = IBTreeView1DragOver |
45 |
|
end |
72 |
|
TabOrder = 0 |
73 |
|
object Label2: TLabel |
74 |
|
Left = 11 |
75 |
< |
Height = 14 |
75 |
> |
Height = 15 |
76 |
|
Top = 16 |
77 |
|
Width = 25 |
78 |
|
Caption = 'Title' |
80 |
|
end |
81 |
|
object DBEdit1: TDBEdit |
82 |
|
Left = 11 |
83 |
< |
Height = 24 |
83 |
> |
Height = 25 |
84 |
|
Top = 31 |
85 |
|
Width = 373 |
86 |
|
DataField = 'DEPARTMENT' |
92 |
|
end |
93 |
|
object Label3: TLabel |
94 |
|
Left = 13 |
95 |
< |
Height = 14 |
95 |
> |
Height = 15 |
96 |
|
Top = 71 |
97 |
|
Width = 51 |
98 |
|
Caption = 'Location' |
100 |
|
end |
101 |
|
object DBEdit4: TDBEdit |
102 |
|
Left = 13 |
103 |
< |
Height = 24 |
103 |
> |
Height = 25 |
104 |
|
Top = 86 |
105 |
|
Width = 179 |
106 |
|
DataField = 'LOCATION' |
111 |
|
end |
112 |
|
object Label4: TLabel |
113 |
|
Left = 219 |
114 |
< |
Height = 14 |
114 |
> |
Height = 15 |
115 |
|
Top = 71 |
116 |
|
Width = 44 |
117 |
|
Caption = 'Budget' |
119 |
|
end |
120 |
|
object DBEdit2: TDBEdit |
121 |
|
Left = 219 |
122 |
< |
Height = 24 |
122 |
> |
Height = 25 |
123 |
|
Top = 86 |
124 |
|
Width = 165 |
125 |
|
DataField = 'BUDGET' |
131 |
|
end |
132 |
|
object Label5: TLabel |
133 |
|
Left = 219 |
134 |
< |
Height = 14 |
134 |
> |
Height = 15 |
135 |
|
Top = 121 |
136 |
|
Width = 61 |
137 |
|
Caption = 'Phone No.' |
139 |
|
end |
140 |
|
object DBEdit3: TDBEdit |
141 |
|
Left = 219 |
142 |
< |
Height = 24 |
142 |
> |
Height = 25 |
143 |
|
Top = 136 |
144 |
|
Width = 165 |
145 |
|
DataField = 'PHONE_NO' |
151 |
|
end |
152 |
|
object Label6: TLabel |
153 |
|
Left = 12 |
154 |
< |
Height = 14 |
154 |
> |
Height = 15 |
155 |
|
Top = 121 |
156 |
|
Width = 52 |
157 |
|
Caption = 'Manager' |
176 |
|
end |
177 |
|
object Label7: TLabel |
178 |
|
Left = 12 |
179 |
< |
Height = 14 |
179 |
> |
Height = 15 |
180 |
|
Top = 172 |
181 |
|
Width = 115 |
182 |
|
Caption = 'Departmental Staff' |
250 |
|
end |
251 |
|
object Label1: TLabel |
252 |
|
Left = 11 |
253 |
< |
Height = 14 |
253 |
> |
Height = 15 |
254 |
|
Top = 17 |
255 |
|
Width = 79 |
256 |
|
Caption = 'Departments' |
277 |
|
TabOrder = 2 |
278 |
|
end |
279 |
|
object IBDatabase1: TIBDatabase |
280 |
< |
Connected = False |
280 |
> |
Connected = True |
281 |
|
CreateIfNotExists = False |
282 |
|
AllowStreamedConnected = False |
283 |
|
DatabaseName = 'localhost:employee' |
312 |
|
AfterInsert = DepartmentsAfterInsert |
313 |
|
BufferChunks = 1000 |
314 |
|
CachedUpdates = False |
315 |
+ |
CaseSensitiveParameterNames = False |
316 |
+ |
EnableStatistics = False |
317 |
|
DeleteSQL.Strings = ( |
318 |
|
'Delete From DEPARTMENT A' |
319 |
|
'Where A.DEPT_NO = :DEPT_NO' |
324 |
|
) |
325 |
|
RefreshSQL.Strings = ( |
326 |
|
'Select A.DEPT_NO, A.DEPARTMENT, A.HEAD_DEPT, A.MNGR_NO, A.BUDGET, A.LOCATION, A.PHONE_NO,' |
327 |
< |
'count(B.DEPT_NO) as ChildCount' |
327 |
> |
'count(B.DEPT_NO) as ChildCount,' |
328 |
> |
'case' |
329 |
> |
' when A.Budget < 500000 then 0' |
330 |
> |
' when A.Budget = 500000 then 2' |
331 |
> |
' else 1 end as ImageIndex' |
332 |
|
'From DEPARTMENT A' |
333 |
|
'Left Outer JOIN DEPARTMENT B On B.HEAD_DEPT = A.DEPT_NO' |
334 |
|
'Where A.DEPT_NO = :DEPT_NO' |
337 |
|
) |
338 |
|
SelectSQL.Strings = ( |
339 |
|
'Select A.DEPT_NO, A.DEPARTMENT, A.HEAD_DEPT, A.MNGR_NO, A.BUDGET, A.LOCATION, A.PHONE_NO,' |
340 |
< |
'count(B.DEPT_NO) as ChildCount' |
340 |
> |
'count(B.DEPT_NO) as ChildCount,' |
341 |
> |
'case' |
342 |
> |
' when A.Budget < 500000 then 0' |
343 |
> |
' when A.Budget = 500000 then 2' |
344 |
> |
' else 1 end as ImageIndex' |
345 |
|
'From DEPARTMENT A' |
346 |
|
'Left Outer JOIN DEPARTMENT B On B.HEAD_DEPT = A.DEPT_NO' |
347 |
|
'Group By A.DEPT_NO, A.DEPARTMENT, A.HEAD_DEPT, A.MNGR_NO, A.BUDGET, A.LOCATION, A.PHONE_NO' |
355 |
|
GeneratorField.Field = 'DEPT_NO' |
356 |
|
GeneratorField.ApplyOnEvent = gaeOnNewRecord |
357 |
|
GenerateParamNames = False |
358 |
+ |
MasterDetailDelay = 0 |
359 |
|
DataSetCloseAction = dcSaveChanges |
360 |
|
AfterTransactionEnd = DepartmentsAfterTransactionEnd |
361 |
< |
left = 64 |
361 |
> |
left = 144 |
362 |
|
top = 176 |
363 |
|
object DepartmentsDEPT_NO: TIBStringField |
364 |
|
DisplayWidth = 3 |
412 |
|
ProviderFlags = [pfInUpdate, pfInWhere] |
413 |
|
ReadOnly = False |
414 |
|
Required = False |
403 |
– |
OnChange = DepartmentsBUDGETChange |
415 |
|
OnGetText = DepartmentsBUDGETGetText |
416 |
|
Precision = 18 |
417 |
|
Currency = False |
440 |
|
ReadOnly = False |
441 |
|
Required = False |
442 |
|
end |
443 |
< |
object DepartmentsCHILDCOUNT: TIntegerField |
433 |
< |
DisplayWidth = 10 |
443 |
> |
object DepartmentsIMAGEINDEX: TIBIntegerField |
444 |
|
FieldKind = fkData |
445 |
< |
FieldName = 'CHILDCOUNT' |
445 |
> |
FieldName = 'IMAGEINDEX' |
446 |
|
Index = 7 |
447 |
|
LookupCache = False |
448 |
|
ProviderFlags = [pfInUpdate, pfInWhere] |
449 |
|
ReadOnly = False |
450 |
|
Required = True |
451 |
|
end |
452 |
+ |
object DepartmentsCHILDCOUNT: TIBLargeIntField |
453 |
+ |
FieldKind = fkData |
454 |
+ |
FieldName = 'CHILDCOUNT' |
455 |
+ |
Index = 8 |
456 |
+ |
LookupCache = False |
457 |
+ |
ProviderFlags = [pfInUpdate, pfInWhere] |
458 |
+ |
ReadOnly = False |
459 |
+ |
Required = True |
460 |
+ |
end |
461 |
|
end |
462 |
|
object DataSource1: TDataSource |
463 |
|
DataSet = Departments |
475 |
|
Transaction = IBTransaction1 |
476 |
|
BufferChunks = 1000 |
477 |
|
CachedUpdates = False |
478 |
+ |
CaseSensitiveParameterNames = False |
479 |
+ |
EnableStatistics = False |
480 |
|
GenerateParamNames = False |
481 |
|
GeneratorField.ApplyOnEvent = gaeOnNewRecord |
482 |
+ |
MasterDetailDelay = 0 |
483 |
|
SQL.Strings = ( |
484 |
|
'Select A.EMP_NO, A.FULL_NAME From EMPLOYEE A' |
485 |
|
'order by 2' |
486 |
|
) |
487 |
|
Params = <> |
488 |
|
DataSetCloseAction = dcDiscardChanges |
489 |
< |
left = 64 |
490 |
< |
top = 221 |
489 |
> |
left = 144 |
490 |
> |
top = 224 |
491 |
|
end |
492 |
|
object DataSource2: TDataSource |
493 |
|
DataSet = Managers |
500 |
|
Transaction = IBTransaction1 |
501 |
|
BufferChunks = 1000 |
502 |
|
CachedUpdates = False |
503 |
+ |
CaseSensitiveParameterNames = False |
504 |
|
DataSource = DataSource1 |
505 |
+ |
EnableStatistics = False |
506 |
|
GenerateParamNames = False |
507 |
|
GeneratorField.ApplyOnEvent = gaeOnNewRecord |
508 |
+ |
MasterDetailDelay = 0 |
509 |
|
SQL.Strings = ( |
510 |
|
'Select A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME From EMPLOYEE A' |
511 |
|
'Where A.DEPT_NO =:DEPT_NO' |
517 |
|
ParamType = ptInput |
518 |
|
end> |
519 |
|
DataSetCloseAction = dcDiscardChanges |
520 |
< |
left = 64 |
521 |
< |
top = 264 |
520 |
> |
left = 144 |
521 |
> |
top = 272 |
522 |
|
ParamData = < |
523 |
|
item |
524 |
|
DataType = ftUnknown |