Marco Web Center |
|
Chapter 15 - Project Ibemp |
Project Structure |
Ibemp.dpr |
program IbEmp; uses Forms, IbEmpF in 'IbEmpF.pas' {FormEmp}; {$R *.RES} begin Application.Initialize; Application.CreateForm(TFormEmp, FormEmp); Application.Run; end. |
IbEmpF.pas |
unit IbEmpF; interface uses SysUtils, Windows, Messages, Classes, Graphics, Controls, StdCtrls, Forms, DBCtrls, DB, DBTables, Mask, ExtCtrls; type TFormEmp = class(TForm) DBNavigator: TDBNavigator; Panel1: TPanel; DataSource1: TDataSource; Panel2: TPanel; Query1: TQuery; ScrollBox: TScrollBox; Label1: TLabel; Label2: TLabel; Label3: TLabel; Label4: TLabel; Label5: TLabel; Label6: TLabel; Label7: TLabel; Label8: TLabel; Label9: TLabel; Label10: TLabel; Label11: TLabel; DBEdit1: TDBEdit; DBEdit2: TDBEdit; DBEdit3: TDBEdit; DBEdit4: TDBEdit; DBEdit5: TDBEdit; DBEdit6: TDBEdit; DBEdit7: TDBEdit; DBEdit8: TDBEdit; DBEdit9: TDBEdit; DBEdit10: TDBEdit; DBEdit11: TDBEdit; procedure FormCreate(Sender: TObject); private { private declarations } public { public declarations } end; var FormEmp: TFormEmp; implementation {$R *.DFM} procedure TFormEmp.FormCreate(Sender: TObject); begin Query1.Open; end; end. |
IbEmpF.dfm |
object FormEmp: TFormEmp Left = 213 Top = 174 Width = 465 Height = 320 ActiveControl = Panel1 Caption = 'InterBase Employee' Color = clBtnFace ParentFont = True OldCreateOrder = True Position = poScreenCenter OnCreate = FormCreate PixelsPerInch = 96 TextHeight = 13 object Panel1: TPanel Left = 0 Top = 0 Width = 457 Height = 41 Align = alTop TabOrder = 0 object DBNavigator: TDBNavigator Left = 8 Top = 8 Width = 240 Height = 25 DataSource = DataSource1 Flat = True Ctl3D = False ParentCtl3D = False TabOrder = 0 end end object Panel2: TPanel Left = 0 Top = 41 Width = 457 Height = 252 Align = alClient BevelInner = bvLowered BorderWidth = 4 Caption = 'Panel2' TabOrder = 1 object ScrollBox: TScrollBox Left = 6 Top = 6 Width = 445 Height = 240 HorzScrollBar.Margin = 6 HorzScrollBar.Range = 132 VertScrollBar.Margin = 6 VertScrollBar.Range = 236 Align = alClient AutoScroll = False BorderStyle = bsNone TabOrder = 0 object Label1: TLabel Left = 40 Top = 24 Width = 45 Height = 13 Caption = 'EMP_NO' FocusControl = DBEdit1 end object Label2: TLabel Left = 40 Top = 64 Width = 68 Height = 13 Caption = 'FIRST_NAME' FocusControl = DBEdit2 end object Label3: TLabel Left = 40 Top = 104 Width = 64 Height = 13 Caption = 'LAST_NAME' FocusControl = DBEdit3 end object Label4: TLabel Left = 40 Top = 144 Width = 65 Height = 13 Caption = 'PHONE_EXT' FocusControl = DBEdit4 end object Label5: TLabel Left = 40 Top = 184 Width = 61 Height = 13 Caption = 'HIRE_DATE' FocusControl = DBEdit5 end object Label6: TLabel Left = 336 Top = 24 Width = 51 Height = 13 Caption = 'DEPT_NO' FocusControl = DBEdit6 end object Label7: TLabel Left = 200 Top = 24 Width = 56 Height = 13 Caption = 'JOB_CODE' FocusControl = DBEdit7 end object Label8: TLabel Left = 200 Top = 64 Width = 64 Height = 13 Caption = 'JOB_GRADE' FocusControl = DBEdit8 end object Label9: TLabel Left = 200 Top = 104 Width = 79 Height = 13 Caption = 'JOB_COUNTRY' FocusControl = DBEdit9 end object Label10: TLabel Left = 200 Top = 144 Width = 42 Height = 13 Caption = 'SALARY' FocusControl = DBEdit10 end object Label11: TLabel Left = 200 Top = 184 Width = 63 Height = 13 Caption = 'FULL_NAME' FocusControl = DBEdit11 end object DBEdit1: TDBEdit Left = 40 Top = 40 Width = 64 Height = 21 DataField = 'EMP_NO' DataSource = DataSource1 TabOrder = 0 end object DBEdit2: TDBEdit Left = 40 Top = 80 Width = 94 Height = 21 DataField = 'FIRST_NAME' DataSource = DataSource1 TabOrder = 1 end object DBEdit3: TDBEdit Left = 40 Top = 120 Width = 124 Height = 21 DataField = 'LAST_NAME' DataSource = DataSource1 TabOrder = 2 end object DBEdit4: TDBEdit Left = 40 Top = 160 Width = 28 Height = 21 DataField = 'PHONE_EXT' DataSource = DataSource1 TabOrder = 3 end object DBEdit5: TDBEdit Left = 40 Top = 200 Width = 112 Height = 21 DataField = 'HIRE_DATE' DataSource = DataSource1 TabOrder = 4 end object DBEdit6: TDBEdit Left = 336 Top = 40 Width = 49 Height = 21 DataField = 'DEPT_NO' DataSource = DataSource1 TabOrder = 5 end object DBEdit7: TDBEdit Left = 200 Top = 40 Width = 34 Height = 21 DataField = 'JOB_CODE' DataSource = DataSource1 TabOrder = 6 end object DBEdit8: TDBEdit Left = 200 Top = 80 Width = 64 Height = 21 DataField = 'JOB_GRADE' DataSource = DataSource1 TabOrder = 7 end object DBEdit9: TDBEdit Left = 200 Top = 120 Width = 94 Height = 21 DataField = 'JOB_COUNTRY' DataSource = DataSource1 TabOrder = 8 end object DBEdit10: TDBEdit Left = 200 Top = 160 Width = 64 Height = 21 DataField = 'SALARY' DataSource = DataSource1 TabOrder = 9 end object DBEdit11: TDBEdit Left = 200 Top = 200 Width = 226 Height = 21 DataField = 'FULL_NAME' DataSource = DataSource1 TabOrder = 10 end end end object Query1: TQuery DatabaseName = 'IBLocal' RequestLive = True SQL.Strings = ( 'SELECT * ' 'FROM EMPLOYEE') Left = 147 Top = 69 end object DataSource1: TDataSource DataSet = Query1 Left = 143 Top = 117 end end |