ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/public/ibx/trunk/examples/employee/unit1.lfm

Comparing ibx/trunk/examples/employee/unit1.lfm (file contents):
Revision 37 by tony, Mon Feb 15 14:44:25 2016 UTC vs.
Revision 107 by tony, Thu Jan 18 14:37:40 2018 UTC

#	Line 1 | Line 1
1		object Form1: TForm1
2	<	Left = 439
2	>	Left = 480
3		Height = 482
4	<	Top = 350
5	<	Width = 1002
4	>	Top = 407
5	>	Width = 932
6		Caption = 'Employee List'
7		ClientHeight = 482
8	<	ClientWidth = 1002
8	>	ClientWidth = 932
9	>	DefaultMonitor = dmPrimary
10		OnClose = FormClose
11		OnShow = FormShow
12	<	LCLVersion = '1.4.4.0'
12	>	Position = poMainFormCenter
13	>	LCLVersion = '1.8.1.0'
14		object Button1: TButton
15	<	Left = 915
15	>	Left = 845
16		Height = 25
17		Top = 48
18		Width = 75
#	Line 19 | Line 21 | object Form1: TForm1
21		TabOrder = 0
22		end
23		object Button2: TButton
24	<	Left = 915
24	>	Left = 845
25		Height = 25
26		Top = 86
27		Width = 75
#	Line 28 | Line 30 | object Form1: TForm1
30		TabOrder = 1
31		end
32		object Button3: TButton
33	<	Left = 915
33	>	Left = 845
34		Height = 25
35		Top = 125
36		Width = 75
#	Line 38 | Line 40 | object Form1: TForm1
40		end
41		object Label1: TLabel
42		Left = 17
43	<	Height = 15
43	>	Height = 14
44		Top = 14
45	<	Width = 74
45	>	Width = 87
46		Caption = 'Started Before'
47		ParentColor = False
48		end
49		object BeforeDate: TDateEdit
50		Left = 112
51	<	Height = 23
51	>	Height = 24
52		Top = 8
53		Width = 80
54		CalendarDisplaySettings = [dsShowHeadings, dsShowDayNames]
53	–	OKCaption = 'OK'
54	–	CancelCaption = 'Cancel'
55		DateOrder = doNone
56		ButtonWidth = 23
57		NumGlyphs = 1
#	Line 61 | Line 61 | object Form1: TForm1
61		end
62		object Label2: TLabel
63		Left = 241
64	<	Height = 15
64	>	Height = 14
65		Top = 14
66	<	Width = 66
66	>	Width = 78
67		Caption = 'Started After'
68		ParentColor = False
69		end
70		object AfterDate: TDateEdit
71		Left = 333
72	<	Height = 23
72	>	Height = 24
73		Top = 8
74		Width = 80
75		CalendarDisplaySettings = [dsShowHeadings, dsShowDayNames]
76	–	OKCaption = 'OK'
77	–	CancelCaption = 'Cancel'
76		DateOrder = doNone
77		ButtonWidth = 23
78		NumGlyphs = 1
#	Line 86 | Line 84 | object Form1: TForm1
84		Left = 12
85		Height = 434
86		Top = 42
87	<	Width = 880
87	>	Width = 810
88		Anchors = [akTop, akLeft, akRight, akBottom]
89		BevelOuter = bvNone
90		ClientHeight = 434
91	<	ClientWidth = 880
91	>	ClientWidth = 810
92		Color = clBackground
93		ParentColor = False
94		TabOrder = 5
#	Line 98 | Line 96 | object Form1: TForm1
96		Left = 0
97		Height = 384
98		Top = 0
99	<	Width = 880
99	>	Width = 810
100		Align = alClient
101		Color = clWindow
102		Columns = <
#	Line 200 | Line 198 | object Form1: TForm1
198		Left = 0
199		Height = 50
200		Top = 384
201	<	Width = 880
201	>	Width = 810
202		Align = alBottom
203		BevelOuter = bvNone
204		ClientHeight = 50
205	<	ClientWidth = 880
205	>	ClientWidth = 810
206		ParentColor = False
207		TabOrder = 1
208		object Button5: TButton
#	Line 229 | Line 227 | object Form1: TForm1
227		Left = 688
228		Height = 27
229		Top = 16
230	<	Width = 43
230	>	Width = 49
231		Alignment = taRightJustify
232		Anchors = [akTop, akLeft, akBottom]
233		DataField = 'TOTALSALARIES'
#	Line 245 | Line 243 | object Form1: TForm1
243		BevelOuter = bvNone
244		BorderWidth = 2
245		BorderStyle = bsSingle
246	<	ClientHeight = 76
247	<	ClientWidth = 780
246	>	ClientHeight = 78
247	>	ClientWidth = 782
248		Color = clWindow
249		ParentColor = False
250		TabOrder = 2
251		Visible = False
252		object Label3: TLabel
253		Left = 0
254	<	Height = 15
254	>	Height = 14
255		Top = 7
256	<	Width = 74
256	>	Width = 83
257		Caption = 'Employee No.'
258		ParentColor = False
259		end
260		object DBEdit1: TDBEdit
261		Left = 90
262	<	Height = 23
262	>	Height = 24
263		Top = 2
264		Width = 120
265		DataField = 'EMP_NO'
#	Line 272 | Line 270 | object Form1: TForm1
270		end
271		object Label4: TLabel
272		Left = 12
273	<	Height = 15
273	>	Height = 14
274		Top = 32
275	<	Width = 57
275	>	Width = 64
276		Caption = 'First Name'
277		ParentColor = False
278		end
279		object DBEdit2: TDBEdit
280		Left = 90
281	<	Height = 23
281	>	Height = 24
282		Top = 24
283		Width = 120
284		DataField = 'FIRST_NAME'
#	Line 291 | Line 289 | object Form1: TForm1
289		end
290		object Label5: TLabel
291		Left = 12
292	<	Height = 15
292	>	Height = 14
293		Top = 56
294	<	Width = 56
294	>	Width = 64
295		Caption = 'Last Name'
296		ParentColor = False
297		end
298		object DBEdit3: TDBEdit
299		Left = 90
300	<	Height = 23
300	>	Height = 24
301		Top = 46
302		Width = 120
303		DataField = 'LAST_NAME'
#	Line 310 | Line 308 | object Form1: TForm1
308		end
309		object Label6: TLabel
310		Left = 216
311	<	Height = 15
311	>	Height = 14
312		Top = 7
313	<	Width = 64
313	>	Width = 77
314		Caption = 'Date Started'
315		ParentColor = False
316		end
317		object IBDateEdit1: TDBDateEdit
318		Left = 300
319	<	Height = 23
319	>	Height = 24
320		Top = 2
321		Width = 104
322		CalendarDisplaySettings = [dsShowHeadings, dsShowDayNames]
325	–	OKCaption = 'OK'
326	–	CancelCaption = 'Cancel'
323		DateOrder = doNone
324		ButtonWidth = 23
325		AutoSelect = False
#	Line 335 | Line 331 | object Form1: TForm1
331		end
332		object Label7: TLabel
333		Left = 252
334	<	Height = 15
334	>	Height = 14
335		Top = 32
336	<	Width = 31
336	>	Width = 37
337		Caption = 'Salary'
338		ParentColor = False
339		end
340		object DBEdit4: TDBEdit
341		Left = 300
342	<	Height = 23
342	>	Height = 24
343		Top = 24
344		Width = 104
345		DataField = 'SALARY'
#	Line 353 | Line 349 | object Form1: TForm1
349		TabOrder = 5
350		end
351		object Label8: TLabel
352	<	Left = 712
353	<	Height = 15
352	>	Left = 708
353	>	Height = 14
354		Top = 54
355	<	Width = 18
355	>	Width = 24
356		Anchors = [akTop, akRight]
357		Caption = 'Ext.'
358		ParentColor = False
359		end
360		object DBEdit5: TDBEdit
361	<	Left = 730
362	<	Height = 23
361	>	Left = 732
362	>	Height = 24
363		Top = 48
364		Width = 40
365		DataField = 'PHONE_EXT'
#	Line 375 | Line 371 | object Form1: TForm1
371		end
372		object Label9: TLabel
373		Left = 536
374	<	Height = 15
374	>	Height = 14
375		Top = 7
376	<	Width = 46
376	>	Width = 51
377		Caption = 'Location'
378		ParentColor = False
379		end
380		object Label10: TLabel
381		Left = 413
382	<	Height = 15
382	>	Height = 14
383		Top = 9
384	<	Width = 52
384	>	Width = 59
385		Caption = 'Job Grade'
386		ParentColor = False
387		end
#	Line 397 | Line 393 | object Form1: TForm1
393		AutoSize = False
394		DataField = 'JOB_GRADE'
395		DataSource = EmployeeSource
396	<	ItemHeight = 15
396	>	ItemHeight = 0
397		Items.Strings = (
398		'1'
399		'2'
#	Line 412 | Line 408 | object Form1: TForm1
408		end
409		object Label11: TLabel
410		Left = 536
411	<	Height = 15
411	>	Height = 14
412		Top = 32
413	<	Width = 44
413	>	Width = 48
414		Caption = 'Job Title'
415		ParentColor = False
416		end
417		object Label12: TLabel
418		Left = 256
419	<	Height = 15
419	>	Height = 14
420		Top = 54
421	<	Width = 28
421	>	Width = 33
422		Caption = 'Dept.'
423		ParentColor = False
424		end
425		object SpeedButton1: TSpeedButton
426	<	Left = 678
426	>	Left = 680
427		Height = 25
428		Top = 48
429		Width = 23
#	Line 436 | Line 432 | object Form1: TForm1
432		end
433		object DBEdit6: TDBEdit
434		Left = 300
435	<	Height = 23
435	>	Height = 24
436		Top = 48
437	<	Width = 370
437	>	Width = 372
438		DataField = 'DEPT_PATH'
439		DataSource = EmployeeSource
440		ReadOnly = True
#	Line 451 | Line 447 | object Form1: TForm1
447		Left = 600
448		Height = 23
449		Top = 0
450	<	Width = 170
450	>	Width = 172
451		Anchors = [akTop, akLeft, akRight]
452		AutoSize = False
453		DataField = 'JOB_COUNTRY'
#	Line 465 | Line 461 | object Form1: TForm1
461		TabOrder = 8
462		AutoInsert = False
463		AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
464	<	ItemHeight = 15
464	>	ItemHeight = 0
465		end
466		object IBLookupComboEditBox1: TIBLookupComboEditBox
467		Left = 600
468		Height = 23
469		Top = 24
470	<	Width = 170
470	>	Width = 172
471		Anchors = [akTop, akLeft, akRight]
472		AutoSize = False
473		DataField = 'JOB_CODE'
#	Line 485 | Line 481 | object Form1: TForm1
481		TabOrder = 9
482		AutoInsert = False
483		AutoCompleteText = [cbactEnabled, cbactEndOfLineComplete, cbactSearchAscending]
484	<	ItemHeight = 15
484	>	ItemHeight = 0
485		end
486		end
487		end
488		object Label13: TLabel
489		Left = 456
490	<	Height = 15
490	>	Height = 14
491		Top = 14
492	<	Width = 67
492	>	Width = 79
493		Caption = 'Salary Range'
494		ParentColor = False
495		end
496		object SalaryRange: TComboBox
497		Left = 544
498	<	Height = 23
498	>	Height = 25
499		Top = 8
500		Width = 272
501	<	ItemHeight = 15
501	>	ItemHeight = 0
502		ItemIndex = 0
503		Items.Strings = (
504		'None Specified'
#	Line 517 | Line 513 | object Form1: TForm1
513		end
514		object IBDatabase1: TIBDatabase
515		Connected = False
516	+	CreateIfNotExists = False
517		AllowStreamedConnected = False
518	<	DatabaseName = 'employee'
518	>	DatabaseName = 'localhost:employee'
519		Params.Strings = (
520		'user_name=SYSDBA'
521		'lc_ctype=UTF8'
#	Line 526 | Line 523 | object Form1: TForm1
523		DefaultTransaction = IBTransaction1
524		IdleTimer = 0
525		TraceFlags = []
526	+	UseDefaultSystemCodePage = False
527		left = 832
528		top = 168
529		end
#	Line 583 | Line 581 | object Form1: TForm1
581		top = 296
582		end
583		object TotalsQuery: TIBQuery
584	+	AllowAutoActivateTransaction = False
585		Database = IBDatabase1
586		Transaction = IBTransaction1
587		BeforeOpen = EmployeesBeforeOpen
#	Line 621 | Line 620 | object Form1: TForm1
620		top = 376
621		end
622		object Employees: TIBDataSet
623	+	AllowAutoActivateTransaction = False
624		Database = IBDatabase1
625		Transaction = IBTransaction1
626	+	ForcedRefresh = True
627		AfterDelete = EmployeesAfterDelete
628		AfterEdit = EmployeesAfterDelete
629		AfterInsert = EmployeesAfterInsert
630		AfterOpen = EmployeesAfterOpen
630	–	AfterPost = EmployeesAfterPost
631		AfterScroll = EmployeesAfterScroll
632		BeforeClose = EmployeesBeforeClose
633		BeforeOpen = EmployeesBeforeOpen
634	<	BufferChunks = 1000
634	>	BufferChunks = 5000
635		CachedUpdates = False
636		DeleteSQL.Strings = (
637		'Delete From EMPLOYEE A'
#	Line 647 | Line 647 | object Form1: TForm1
647		'cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH'
648		'From DEPARTMENT Where HEAD_DEPT is NULL '
649		'UNION ALL'
650	<	'Select DEPT_NO, DEPARTMENT, HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || DEPARTMENT as DEPT_PATH,'
651	<	'Depts.DEPT_KEY_PATH || '';'' || DEPT_NO as DEPT_KEY_PATH'
652	<	'From DEPARTMENT  '
653	<	'JOIN Depts On HEAD_DEPT = Depts.DEPT_NO'
650	>	'Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || D.DEPARTMENT as DEPT_PATH,'
651	>	'Depts.DEPT_KEY_PATH || '';'' || D.DEPT_NO as DEPT_KEY_PATH'
652	>	'From DEPARTMENT  D'
653	>	'JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO'
654		')'
655		''
656		'Select A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, '
657		'A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH'
658		'From EMPLOYEE A'
659		'JOIN Depts D On D.DEPT_NO = A.DEPT_NO'
660	+	''
661		'Where A.EMP_NO = :EMP_NO'
662		)
663		SelectSQL.Strings = (
#	Line 665 | Line 666 | object Form1: TForm1
666		'cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH'
667		'From DEPARTMENT Where HEAD_DEPT is NULL '
668		'UNION ALL'
669	<	'Select DEPT_NO, DEPARTMENT, HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || DEPARTMENT as DEPT_PATH,'
670	<	'Depts.DEPT_KEY_PATH || '';'' || DEPT_NO as DEPT_KEY_PATH'
671	<	'From DEPARTMENT  '
672	<	'JOIN Depts On HEAD_DEPT = Depts.DEPT_NO'
669	>	'Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || D.DEPARTMENT as DEPT_PATH,'
670	>	'Depts.DEPT_KEY_PATH || '';'' || D.DEPT_NO as DEPT_KEY_PATH'
671	>	'From DEPARTMENT  D'
672	>	'JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO'
673		')'
674		''
675	<	'Select A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, '
675	>	'Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, '
676		'A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH'
677		'From EMPLOYEE A'
678		'JOIN Depts D On D.DEPT_NO = A.DEPT_NO'
#	Line 838 | Line 839 | object Form1: TForm1
839		end
840		end
841		object Countries: TIBQuery
842	+	AllowAutoActivateTransaction = False
843		Database = IBDatabase1
844		Transaction = IBTransaction1
845		BeforeOpen = CountriesBeforeOpen
#	Line 883 | Line 885 | object Form1: TForm1
885		top = 256
886		end
887		object JobCodes: TIBQuery
888	+	AllowAutoActivateTransaction = False
889		Database = IBDatabase1
890		Transaction = IBTransaction1
891		BeforeOpen = JobCodesBeforeOpen
#	Line 922 | Line 925 | object Form1: TForm1
925		end>
926		end
927		object Depts: TIBQuery
928	+	AllowAutoActivateTransaction = False
929		Database = IBDatabase1
930		Transaction = IBTransaction1
931		BufferChunks = 1000
#	Line 946 | Line 950 | object Form1: TForm1
950		object JobGradeChangeTimer: TTimer
951		Interval = 0
952		OnTimer = JobGradeChangeTimerTimer
953	<	left = 928
954	<	top = 175
953	>	left = 777
954	>	top = 304
955		end
956		object JobCodeChangeTimer: TTimer
957		Interval = 0
958		OnTimer = JobCodeChangeTimerTimer
959	<	left = 927
960	<	top = 224
959	>	left = 776
960	>	top = 353
961		end
962		end

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines