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 27 by tony, Tue Apr 14 13:10:23 2015 UTC vs.
Revision 291 by tony, Fri Apr 17 10:26:08 2020 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.3'
12	>	Position = poMainFormCenter
13	>	LCLVersion = '2.0.5.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 = 17
44		Top = 14
45	<	Width = 87
45	>	Width = 82
46		Caption = 'Started Before'
47		ParentColor = False
48		end
49		object BeforeDate: TDateEdit
50		Left = 112
51	<	Height = 25
51	>	Height = 27
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 = 17
65		Top = 14
66	<	Width = 78
66	>	Width = 72
67		Caption = 'Started After'
68		ParentColor = False
69		end
70		object AfterDate: TDateEdit
71		Left = 333
72	<	Height = 25
72	>	Height = 27
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 = 49
230	>	Width = 47
231		Alignment = taRightJustify
232		Anchors = [akTop, akLeft, akBottom]
233		DataField = 'TOTALSALARIES'
#	Line 253 | Line 251 | object Form1: TForm1
251		Visible = False
252		object Label3: TLabel
253		Left = 0
254	<	Height = 15
254	>	Height = 17
255		Top = 7
256	<	Width = 83
256	>	Width = 77
257		Caption = 'Employee No.'
258		ParentColor = False
259		end
260		object DBEdit1: TDBEdit
261		Left = 90
262	<	Height = 25
262	>	Height = 27
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 = 17
274		Top = 32
275	<	Width = 64
275	>	Width = 61
276		Caption = 'First Name'
277		ParentColor = False
278		end
279		object DBEdit2: TDBEdit
280		Left = 90
281	<	Height = 25
281	>	Height = 27
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 = 17
293		Top = 56
294	<	Width = 64
294	>	Width = 60
295		Caption = 'Last Name'
296		ParentColor = False
297		end
298		object DBEdit3: TDBEdit
299		Left = 90
300	<	Height = 25
300	>	Height = 27
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 = 17
312		Top = 7
313	<	Width = 77
313	>	Width = 71
314		Caption = 'Date Started'
315		ParentColor = False
316		end
317		object IBDateEdit1: TDBDateEdit
318		Left = 300
319	<	Height = 25
319	>	Height = 27
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
#	Line 335 | Line 331 | object Form1: TForm1
331		end
332		object Label7: TLabel
333		Left = 252
334	<	Height = 15
334	>	Height = 17
335		Top = 32
336	<	Width = 37
336	>	Width = 35
337		Caption = 'Salary'
338		ParentColor = False
339		end
340		object DBEdit4: TDBEdit
341		Left = 300
342	<	Height = 25
342	>	Height = 27
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 = 708
353	<	Height = 15
352	>	Left = 712
353	>	Height = 17
354		Top = 54
355	<	Width = 24
355	>	Width = 20
356		Anchors = [akTop, akRight]
357		Caption = 'Ext.'
358		ParentColor = False
359		end
360		object DBEdit5: TDBEdit
361		Left = 732
362	<	Height = 25
362	>	Height = 27
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 = 17
375		Top = 7
376	<	Width = 51
376	>	Width = 47
377		Caption = 'Location'
378		ParentColor = False
379		end
380		object Label10: TLabel
381		Left = 413
382	<	Height = 15
382	>	Height = 17
383		Top = 9
384	<	Width = 59
384	>	Width = 55
385		Caption = 'Job Grade'
386		ParentColor = False
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 412 | Line 408 | object Form1: TForm1
408		end
409		object Label11: TLabel
410		Left = 536
411	<	Height = 15
411	>	Height = 17
412		Top = 32
413	<	Width = 48
413	>	Width = 44
414		Caption = 'Job Title'
415		ParentColor = False
416		end
417		object Label12: TLabel
418		Left = 256
419	<	Height = 15
419	>	Height = 17
420		Top = 54
421	<	Width = 33
421	>	Width = 30
422		Caption = 'Dept.'
423		ParentColor = False
424		end
#	Line 436 | Line 432 | object Form1: TForm1
432		end
433		object DBEdit6: TDBEdit
434		Left = 300
435	<	Height = 25
435	>	Height = 27
436		Top = 48
437		Width = 372
438		DataField = 'DEPT_PATH'
#	Line 449 | 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 469 | 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 491 | Line 487 | object Form1: TForm1
487		end
488		object Label13: TLabel
489		Left = 456
490	<	Height = 15
490	>	Height = 17
491		Top = 14
492	<	Width = 79
492	>	Width = 73
493		Caption = 'Salary Range'
494		ParentColor = False
495		end
496		object SalaryRange: TComboBox
497		Left = 544
498	<	Height = 25
498	>	Height = 27
499		Top = 8
500		Width = 272
501		ItemHeight = 0
#	Line 517 | Line 513 | object Form1: TForm1
513		end
514		object IBDatabase1: TIBDatabase
515		Connected = False
516	+	CreateIfNotExists = False
517		AllowStreamedConnected = False
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 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
588		BufferChunks = 1000
589		CachedUpdates = False
590	+	CaseSensitiveParameterNames = False
591	+	EnableStatistics = False
592		GenerateParamNames = False
593		GeneratorField.ApplyOnEvent = gaeOnNewRecord
594	+	MasterDetailDelay = 0
595		SQL.Strings = (
596		'Select sum(Salary) as TotalSalaries'
597		'From EMPLOYEE'
#	Line 621 | Line 623 | object Form1: TForm1
623		top = 376
624		end
625		object Employees: TIBDataSet
626	+	AllowAutoActivateTransaction = False
627		Database = IBDatabase1
628		Transaction = IBTransaction1
629	+	ForcedRefresh = True
630		AfterDelete = EmployeesAfterDelete
631		AfterEdit = EmployeesAfterDelete
632		AfterInsert = EmployeesAfterInsert
633		AfterOpen = EmployeesAfterOpen
630	–	AfterPost = EmployeesAfterPost
634		AfterScroll = EmployeesAfterScroll
635		BeforeClose = EmployeesBeforeClose
636		BeforeOpen = EmployeesBeforeOpen
637	<	BufferChunks = 1000
637	>	BufferChunks = 5000
638		CachedUpdates = False
639	+	CaseSensitiveParameterNames = True
640	+	EnableStatistics = False
641		DeleteSQL.Strings = (
642		'Delete From EMPLOYEE A'
643		'Where A.EMP_NO = :EMP_NO'
#	Line 647 | Line 652 | object Form1: TForm1
652		'cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH'
653		'From DEPARTMENT Where HEAD_DEPT is NULL '
654		'UNION ALL'
655	<	'Select DEPT_NO, DEPARTMENT, HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || DEPARTMENT as DEPT_PATH,'
656	<	'Depts.DEPT_KEY_PATH || '';'' || DEPT_NO as DEPT_KEY_PATH'
657	<	'From DEPARTMENT  '
658	<	'JOIN Depts On HEAD_DEPT = Depts.DEPT_NO'
655	>	'Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || D.DEPARTMENT as DEPT_PATH,'
656	>	'Depts.DEPT_KEY_PATH || '';'' || D.DEPT_NO as DEPT_KEY_PATH'
657	>	'From DEPARTMENT  D'
658	>	'JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO'
659		')'
660		''
661		'Select A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, '
662		'A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH'
663		'From EMPLOYEE A'
664		'JOIN Depts D On D.DEPT_NO = A.DEPT_NO'
665	+	''
666		'Where A.EMP_NO = :EMP_NO'
667		)
668		SelectSQL.Strings = (
#	Line 665 | Line 671 | object Form1: TForm1
671		'cast(DEPT_NO as VarChar(64)) as DEPT_KEY_PATH'
672		'From DEPARTMENT Where HEAD_DEPT is NULL '
673		'UNION ALL'
674	<	'Select DEPT_NO, DEPARTMENT, HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || DEPARTMENT as DEPT_PATH,'
675	<	'Depts.DEPT_KEY_PATH || '';'' || DEPT_NO as DEPT_KEY_PATH'
676	<	'From DEPARTMENT  '
677	<	'JOIN Depts On HEAD_DEPT = Depts.DEPT_NO'
674	>	'Select D.DEPT_NO, D.DEPARTMENT, D.HEAD_DEPT, Depts.DEPT_PATH ||  '' / '' || D.DEPARTMENT as DEPT_PATH,'
675	>	'Depts.DEPT_KEY_PATH || '';'' || D.DEPT_NO as DEPT_KEY_PATH'
676	>	'From DEPARTMENT  D'
677	>	'JOIN Depts On D.HEAD_DEPT = Depts.DEPT_NO'
678		')'
679		''
680	<	'Select A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, '
680	>	'Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE, '
681		'A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH'
682		'From EMPLOYEE A'
683		'JOIN Depts D On D.DEPT_NO = A.DEPT_NO'
#	Line 684 | Line 690 | object Form1: TForm1
690		GeneratorField.Field = 'EMP_NO'
691		GeneratorField.ApplyOnEvent = gaeOnNewRecord
692		GenerateParamNames = False
693	+	MasterDetailDelay = 0
694		DataSetCloseAction = dcSaveChanges
695		AfterTransactionEnd = EmployeesAfterTransactionEnd
696		OnValidatePost = EmployeesValidatePost
#	Line 838 | Line 845 | object Form1: TForm1
845		end
846		end
847		object Countries: TIBQuery
848	+	AllowAutoActivateTransaction = False
849		Database = IBDatabase1
850		Transaction = IBTransaction1
851		BeforeOpen = CountriesBeforeOpen
852		BufferChunks = 1000
853		CachedUpdates = False
854	+	CaseSensitiveParameterNames = False
855	+	EnableStatistics = False
856		GenerateParamNames = False
857		GeneratorField.ApplyOnEvent = gaeOnNewRecord
858	+	MasterDetailDelay = 0
859		SQL.Strings = (
860		'Select A.COUNTRY, A.CURRENCY From COUNTRY A'
861		'JOIN JOB J On J.JOB_COUNTRY = A.COUNTRY'
#	Line 883 | Line 894 | object Form1: TForm1
894		top = 256
895		end
896		object JobCodes: TIBQuery
897	+	AllowAutoActivateTransaction = False
898		Database = IBDatabase1
899		Transaction = IBTransaction1
900		BeforeOpen = JobCodesBeforeOpen
901		BufferChunks = 1000
902		CachedUpdates = False
903	+	CaseSensitiveParameterNames = False
904	+	EnableStatistics = False
905		GenerateParamNames = False
906		GeneratorField.ApplyOnEvent = gaeOnNewRecord
907	+	MasterDetailDelay = 0
908		SQL.Strings = (
909		'Select A.JOB_CODE, A.JOB_TITLE From JOB A'
910		'Where JOB_COUNTRY = :JOB_COUNTRY and JOB_GRADE = :JOB_GRADE'
#	Line 922 | Line 937 | object Form1: TForm1
937		end>
938		end
939		object Depts: TIBQuery
940	+	AllowAutoActivateTransaction = False
941		Database = IBDatabase1
942		Transaction = IBTransaction1
943		BufferChunks = 1000
944		CachedUpdates = False
945	+	CaseSensitiveParameterNames = False
946	+	EnableStatistics = False
947		GenerateParamNames = False
948		GeneratorField.ApplyOnEvent = gaeOnNewRecord
949	+	MasterDetailDelay = 0
950		SQL.Strings = (
951		'Select A.DEPT_NO, A.DEPARTMENT From DEPARTMENT A'
952		''
#	Line 943 | Line 962 | object Form1: TForm1
962		left = 832
963		top = 208
964		end
965	+	object JobGradeChangeTimer: TTimer
966	+	Interval = 0
967	+	OnTimer = JobGradeChangeTimerTimer
968	+	left = 777
969	+	top = 304
970	+	end
971	+	object JobCodeChangeTimer: TTimer
972	+	Interval = 0
973	+	OnTimer = JobCodeChangeTimerTimer
974	+	left = 776
975	+	top = 353
976	+	end
977		end

Diff Legend

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