impdlgibxf.dfm

EMS Advanced Import Component Suite 允许你把数据从文件导入数据库中

object fmImpDlgIBX: TfmImpDlgIBX
  Left = 307
  Top = 217
  Width = 552
  Height = 354
  Caption = 'EMS QuickImport3 -- TQImport3Wizard IBX Demo'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = True
  Position = poScreenCenter
  OnCreate = FormCreate
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 13
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 544
    Height = 31
    Align = alTop
    BevelInner = bvLowered
    BevelOuter = bvNone
    TabOrder = 0
    object btImport: TButton
      Left = 6
      Top = 3
      Width = 75
      Height = 25
      Caption = 'Import data...'
      TabOrder = 0
      OnClick = btImportClick
    end
    object chbUseBeforePost: TCheckBox
      Left = 96
      Top = 8
      Width = 257
      Height = 17
      Caption = 'Use before post event'
      TabOrder = 1
    end
    object Button1: TButton
      Left = 462
      Top = 3
      Width = 75
      Height = 25
      Caption = 'Empty table'
      TabOrder = 2
      OnClick = Button1Click
    end
  end
  object pcDestinations: TPageControl
    Left = 0
    Top = 31
    Width = 544
    Height = 296
    ActivePage = tshDataSet
    Align = alClient
    TabOrder = 1
    OnChange = pcDestinationsChange
    object tshDataSet: TTabSheet
      Caption = 'Dataset'
      object dgrDataSet: TDBGrid
        Left = 0
        Top = 0
        Width = 536
        Height = 268
        Align = alClient
        DataSource = DataSource1
        TabOrder = 0
        TitleFont.Charset = DEFAULT_CHARSET
        TitleFont.Color = clWindowText
        TitleFont.Height = -11
        TitleFont.Name = 'MS Sans Serif'
        TitleFont.Style = []
      end
    end
    object tshDBGrid: TTabSheet
      Caption = 'DBGrid'
      object DBGrid: TDBGrid
        Left = 0
        Top = 0
        Width = 536
        Height = 268
        Align = alClient
        DataSource = DataSource1
        TabOrder = 0
        TitleFont.Charset = DEFAULT_CHARSET
        TitleFont.Color = clWindowText
        TitleFont.Height = -11
        TitleFont.Name = 'MS Sans Serif'
        TitleFont.Style = []
        Columns = <
          item
            Expanded = False
            FieldName = 'NAME'
            Title.Alignment = taCenter
            Title.Caption = 'Country Name'
            Width = 110
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'CONTINENT'
            Title.Alignment = taCenter
            Title.Caption = 'Country Continent'
            Width = 110
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'POPULATION'
            Title.Alignment = taCenter
            Title.Caption = 'Country Population'
            Width = 110
            Visible = True
          end>
      end
    end
    object tshListView: TTabSheet
      Caption = 'ListView'
      object ListView: TListView
        Left = 0
        Top = 0
        Width = 536
        Height = 268
        Align = alClient
        Columns = <
          item
            Caption = 'NAME'
            Width = 110
          end
          item
            Caption = 'CAPITAL'
            Width = 110
          end
          item
            Caption = 'CONTINENT'
            Width = 110
          end
          item
            Caption = 'AREA'
            Width = 90
          end
          item
            Caption = 'POPULATION'
            Width = 90
          end>
        TabOrder = 0
        ViewStyle = vsReport
      end
    end
    object tshStringGrid: TTabSheet
      Caption = 'StringGrid'
      object StringGrid: TStringGrid
        Left = 0
        Top = 0
        Width = 536
        Height = 268
        Align = alClient
        DefaultColWidth = 100
        DefaultRowHeight = 18
        FixedCols = 0
        RowCount = 2
        TabOrder = 0
      end
    end
  end
  object QImportWizard1: TQImport3Wizard
    DataSet = IBTable1
    DBGrid = DBGrid
    ListView = ListView
    StringGrid = StringGrid
    Formats.BooleanTrue.Strings = (
      'True')
    Formats.BooleanFalse.Strings = (
      'False')
    Formats.NullValues.Strings = (
      'Null')
    FieldFormats = <>
    ErrorLogFileName = 'error.log'
    ShowSaveLoadButtons = True
    AddType = qatInsert
    GridCaptionRow = 0
    GridStartRow = 1
    OnAfterImport = QImportWizard1AfterImport
    OnNeedCommit = QImportWizard1NeedCommit
    OnBeforePost = QImportWizard1BeforePost
    Left = 104
    Top = 120
  end
  object DataSource1: TDataSource
    DataSet = IBTable1
    Left = 76
    Top = 120
  end
  object IBTable1: TIBTable
    Database = IBDatabase1
    Transaction = IBTransaction1
    BufferChunks = 1000
    CachedUpdates = False
    FieldDefs = <
      item
        Name = 'NAME'
        DataType = ftString
        Size = 50
      end
      item
        Name = 'CAPITAL'
        DataType = ftString
        Size = 50
      end
      item
        Name = 'CONTINENT'
        DataType = ftString
        Size = 50
      end
      item
        Name = 'AREA'
        DataType = ftFloat
      end
      item
        Name = 'POPULATION'
        DataType = ftFloat
      end>
    StoreDefs = True
    TableName = 'COUNTRY'
    Left = 48
    Top = 120
  end
  object IBDatabase1: TIBDatabase
    Params.Strings = (
      'user_name=SYSDBA'
      'password=masterkey')
    LoginPrompt = False
    IdleTimer = 0
    SQLDialect = 1
    TraceFlags = []
    Left = 48
    Top = 148
  end
  object IBTransaction1: TIBTransaction
    Active = False
    DefaultDatabase = IBDatabase1
    Params.Strings = (
      'read_committed'
      'rec_version'
      'nowait')
    Left = 76
    Top = 148
  end
  object IBQuery1: TIBQuery
    Database = IBDatabase1
    Transaction = IBTransaction1
    BufferChunks = 1000
    CachedUpdates = False
    SQL.Strings = (
      'delete from country')
    Left = 49
    Top = 176
  end
end