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 23 by tony, Fri Mar 13 10:26:52 2015 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.0.1'
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 = 87
46		Caption = 'Started Before'
#	Line 46 | Line 48 | object Form1: TForm1
48		end
49		object BeforeDate: TDateEdit
50		Left = 112
51	<	Height = 25
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 = 78
67		Caption = 'Started After'
#	Line 69 | Line 69 | object Form1: TForm1
69		end
70		object AfterDate: TDateEdit
71		Left = 333
72	<	Height = 25
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 253 | Line 251 | object Form1: TForm1
251		Visible = False
252		object Label3: TLabel
253		Left = 0
254	<	Height = 15
254	>	Height = 14
255		Top = 7
256		Width = 83
257		Caption = 'Employee No.'
#	Line 261 | Line 259 | object Form1: TForm1
259		end
260		object DBEdit1: TDBEdit
261		Left = 90
262	<	Height = 25
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 = 64
276		Caption = 'First Name'
#	Line 280 | Line 278 | object Form1: TForm1
278		end
279		object DBEdit2: TDBEdit
280		Left = 90
281	<	Height = 25
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 = 64
295		Caption = 'Last Name'
#	Line 299 | Line 297 | object Form1: TForm1
297		end
298		object DBEdit3: TDBEdit
299		Left = 90
300	<	Height = 25
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 = 77
314		Caption = 'Date Started'
#	Line 318 | Line 316 | object Form1: TForm1
316		end
317		object IBDateEdit1: TDBDateEdit
318		Left = 300
319	<	Height = 25
319	>	Height = 24
320		Top = 2
321	<	Width = 80
321	>	Width = 104
322		CalendarDisplaySettings = [dsShowHeadings, dsShowDayNames]
325	–	OKCaption = 'OK'
326	–	CancelCaption = 'Cancel'
323		DateOrder = doNone
324		ButtonWidth = 23
325	+	AutoSelect = False
326		NumGlyphs = 1
327		MaxLength = 0
328		TabOrder = 3
#	Line 334 | 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 = 37
337		Caption = 'Salary'
#	Line 342 | Line 339 | object Form1: TForm1
339		end
340		object DBEdit4: TDBEdit
341		Left = 300
342	<	Height = 25
342	>	Height = 24
343		Top = 24
344		Width = 104
345		DataField = 'SALARY'
#	Line 353 | Line 350 | object Form1: TForm1
350		end
351		object Label8: TLabel
352		Left = 708
353	<	Height = 15
353	>	Height = 14
354		Top = 54
355		Width = 24
356		Anchors = [akTop, akRight]
#	Line 362 | Line 359 | object Form1: TForm1
359		end
360		object DBEdit5: TDBEdit
361		Left = 732
362	<	Height = 25
362	>	Height = 24
363		Top = 48
364		Width = 40
365		DataField = 'PHONE_EXT'
#	Line 374 | 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 = 51
377		Caption = 'Location'
#	Line 382 | Line 379 | object Form1: TForm1
379		end
380		object Label10: TLabel
381		Left = 413
382	<	Height = 15
382	>	Height = 14
383		Top = 9
384		Width = 59
385		Caption = 'Job Grade'
#	Line 390 | Line 387 | object Form1: TForm1
387		end
388		object JobGradeDBComboBox: TDBComboBox
389		Left = 480
390	<	Height = 25
390	>	Height = 23
391		Top = 2
392		Width = 48
393		AutoSize = False
#	Line 411 | 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 = 48
414		Caption = 'Job Title'
#	Line 419 | Line 416 | object Form1: TForm1
416		end
417		object Label12: TLabel
418		Left = 256
419	<	Height = 15
419	>	Height = 14
420		Top = 54
421		Width = 33
422		Caption = 'Dept.'
#	Line 435 | Line 432 | object Form1: TForm1
432		end
433		object DBEdit6: TDBEdit
434		Left = 300
435	<	Height = 25
435	>	Height = 24
436		Top = 48
437		Width = 372
438		DataField = 'DEPT_PATH'
#	Line 448 | Line 445 | object Form1: TForm1
445		end
446		object IBLookupComboEditBox2: TIBLookupComboEditBox
447		Left = 600
448	<	Height = 25
448	>	Height = 23
449		Top = 0
450		Width = 172
451		Anchors = [akTop, akLeft, akRight]
#	Line 468 | Line 465 | object Form1: TForm1
465		end
466		object IBLookupComboEditBox1: TIBLookupComboEditBox
467		Left = 600
468	<	Height = 25
468	>	Height = 23
469		Top = 24
470		Width = 172
471		Anchors = [akTop, akLeft, akRight]
#	Line 490 | Line 487 | object Form1: TForm1
487		end
488		object Label13: TLabel
489		Left = 456
490	<	Height = 15
490	>	Height = 14
491		Top = 14
492		Width = 79
493		Caption = 'Salary Range'
#	Line 516 | 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=UTF-8'
521	>	'lc_ctype=UTF8'
522		)
523		DefaultTransaction = IBTransaction1
524		IdleTimer = 0
525		TraceFlags = []
526	+	UseDefaultSystemCodePage = False
527		left = 832
528		top = 168
529		end
#	Line 582 | 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 594 | Line 594 | object Form1: TForm1
594		'From EMPLOYEE'
595		)
596		Params = <>
597	+	DataSetCloseAction = dcDiscardChanges
598		left = 872
599		top = 376
600		object TotalsQueryTOTALSALARIES: TIBBCDField
#	Line 619 | 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
628	–	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 645 | 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 663 | 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 682 | Line 685 | object Form1: TForm1
685		GeneratorField.Field = 'EMP_NO'
686		GeneratorField.ApplyOnEvent = gaeOnNewRecord
687		GenerateParamNames = False
688	+	DataSetCloseAction = dcSaveChanges
689		AfterTransactionEnd = EmployeesAfterTransactionEnd
690	+	OnValidatePost = EmployeesValidatePost
691		left = 872
692		top = 336
693		object EmployeesEMP_NO: TSmallintField
#	Line 834 | 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 858 | Line 864 | object Form1: TForm1
864		Name = 'JOB_GRADE'
865		ParamType = ptInput
866		end>
867	+	DataSetCloseAction = dcDiscardChanges
868		left = 872
869		top = 296
870		ParamData = <
#	Line 878 | 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 901 | Line 909 | object Form1: TForm1
909		Name = 'JOB_GRADE'
910		ParamType = ptInput
911		end>
912	+	DataSetCloseAction = dcDiscardChanges
913		left = 872
914		top = 256
915		ParamData = <
#	Line 916 | 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 928 | Line 938 | object Form1: TForm1
938		'Order by Upper(Department)'
939		)
940		Params = <>
941	+	DataSetCloseAction = dcDiscardChanges
942		left = 872
943		top = 210
944		end
#	Line 936 | Line 947 | object Form1: TForm1
947		left = 832
948		top = 208
949		end
950	+	object JobGradeChangeTimer: TTimer
951	+	Interval = 0
952	+	OnTimer = JobGradeChangeTimerTimer
953	+	left = 777
954	+	top = 304
955	+	end
956	+	object JobCodeChangeTimer: TTimer
957	+	Interval = 0
958	+	OnTimer = JobCodeChangeTimerTimer
959	+	left = 776
960	+	top = 353
961	+	end
962		end

Diff Legend

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