filterandindex.xfm

Crlab公司用来连接MySQL数据库的控件

inherited FilterAndIndexFrame: TFilterAndIndexFrame
  Width = 652
  Height = 372
  HorzScrollBar.Range = 166
  VertScrollBar.Range = 47
  Align = alClient
  object DBGrid: TDBGrid
    Left = 166
    Top = 47
    Width = 486
    Height = 325
    Align = alClient
    DataSource = DataSource
    Font.Color = clText
    Font.Height = 11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpVariable
    Font.Style = []
    ParentFont = False
    TabOrder = 0
    TitleFont.Color = clText
    TitleFont.Height = 11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
  end
  object Panel3: TPanel
    Left = 0
    Top = 47
    Width = 166
    Height = 325
    Align = alLeft
    BevelOuter = bvNone
    TabOrder = 1
    object Panel8: TPanel
      Left = 0
      Top = 241
      Width = 166
      Height = 84
      Align = alBottom
      BevelOuter = bvNone
      Caption = 'Panel8'
      Color = 16591631
      ParentColor = False
      TabOrder = 0
      object Panel7: TPanel
        Left = 1
        Top = 1
        Width = 164
        Height = 82
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 0
        object Label1: TLabel
          Left = 6
          Top = 3
          Width = 86
          Height = 13
          Caption = 'IndexFieldNames ='
        end
        object lbIndexFieldNames: TLabel
          Left = 6
          Top = 22
          Width = 145
          Height = 54
          AutoSize = False
          WordWrap = True
        end
      end
    end
    object lbFields: TListBox
      Left = 0
      Top = 0
      Width = 166
      Height = 241
      Align = alClient
      ItemHeight = 13
      MultiSelect = True
      TabOrder = 1
      OnClick = lbFieldsClick
    end
  end
  object Panel4: TPanel
    Left = 0
    Top = 0
    Width = 652
    Height = 47
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 2
    object ToolBar: TPanel
      Left = 0
      Top = 0
      Width = 642
      Height = 47
      Align = alLeft
      BevelOuter = bvNone
      Color = 16591631
      ParentColor = False
      TabOrder = 0
      object btClose: TSpeedButton
        Left = 84
        Top = 1
        Width = 82
        Height = 22
        Caption = 'Close'
        Flat = True
        Transparent = False
        OnClick = btCloseClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Top = 1
        Width = 82
        Height = 22
        Caption = 'Open'
        Flat = True
        Transparent = False
        OnClick = btOpenClick
      end
      object Panel5: TPanel
        Left = 388
        Top = 24
        Width = 145
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 0
        object cbCalcFields: TCheckBox
          Left = 5
          Top = 1
          Width = 142
          Height = 22
          Caption = 'Calculated/Lookup fields'
          Color = clButton
          ParentColor = False
          TabOrder = 0
          OnClick = cbCalcFieldsClick
        end
      end
      object Panel2: TPanel
        Left = 167
        Top = 24
        Width = 220
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 1
        object cbFilter: TCheckBox
          Left = 5
          Top = 1
          Width = 54
          Height = 21
          Caption = 'Filter'
          Color = clButton
          Font.Color = clText
          Font.Height = 11
          Font.Name = 'MS Sans Serif'
          Font.Pitch = fpVariable
          Font.Style = [fsBold]
          ParentColor = False
          ParentFont = False
          TabOrder = 0
          OnClick = cbFilterClick
        end
        object edFilter: TEdit
          Left = 70
          Top = 2
          Width = 144
          Height = 21
          Anchors = [akLeft, akTop, akRight]
          TabOrder = 1
          Text = 'DEPTNO = 10'
          OnExit = edFilterExit
        end
      end
      object Panel9: TPanel
        Left = 167
        Top = 1
        Width = 220
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 2
        object DBNavigator1: TDBNavigator
          Left = 0
          Top = 0
          Width = 220
          Height = 22
          DataSource = DataSource
          Flat = True
          TabOrder = 0
        end
      end
      object Panel1: TPanel
        Left = 534
        Top = 24
        Width = 107
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 3
        object cbCacheCalcFields: TCheckBox
          Left = 6
          Top = 1
          Width = 103
          Height = 22
          Caption = 'CacheCalcFields'
          Color = clButton
          ParentColor = False
          TabOrder = 0
          OnClick = cbCacheCalcFieldsClick
        end
      end
      object Panel6: TPanel
        Left = 388
        Top = 1
        Width = 253
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 4
      end
      object TPanel
        Left = 2
        Top = 24
        Width = 164
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 5
        object cbIndex: TCheckBox
          Left = 8
          Top = 1
          Width = 111
          Height = 20
          Caption = 'Index'
          Color = clButton
          Font.Color = clText
          Font.Height = 11
          Font.Name = 'MS Sans Serif'
          Font.Pitch = fpVariable
          Font.Style = [fsBold]
          ParentColor = False
          ParentFont = False
          TabOrder = 0
          OnClick = cbIndexClick
        end
      end
    end
  end
  object Query: TMyQuery
    Connection = MyDACForm.MyConnection
    SQL.Strings = (
      'SELECT * FROM EMP')
    Debug = True
    RefreshOptions = [roAfterInsert, roAfterUpdate]
    Left = 272
    Top = 55
  end
  object DataSource: TDataSource
    DataSet = Query
    Left = 304
    Top = 55
  end
  object Query2: TMyQuery
    Connection = MyDACForm.MyConnection
    SQL.Strings = (
      'SELECT * FROM EMP')
    Debug = True
    OnCalcFields = Query2CalcFields
    Left = 272
    Top = 88
    object Query2CALCULATED: TIntegerField
      FieldKind = fkCalculated
      FieldName = 'CALCULATED'
      Calculated = True
    end
    object Query2LOOKUP: TStringField
      FieldKind = fkLookup
      FieldName = 'LOOKUP'
      LookupDataSet = LookupQuery
      LookupKeyFields = 'DEPTNO'
      LookupResultField = 'DNAME'
      KeyFields = 'DEPTNO'
      Lookup = True
    end
    object Query2EMPNO: TIntegerField
      FieldName = 'EMPNO'
      Required = True
    end
    object Query2ENAME: TStringField
      FieldName = 'ENAME'
      Size = 10
    end
    object Query2JOB: TStringField
      FieldName = 'JOB'
      Size = 9
    end
    object Query2MGR: TIntegerField
      FieldName = 'MGR'
    end
    object Query2HIREDATE: TDateTimeField
      FieldName = 'HIREDATE'
    end
    object Query2SAL: TFloatField
      FieldName = 'SAL'
    end
    object Query2COMM: TFloatField
      FieldName = 'COMM'
    end
    object Query2DEPTNO: TIntegerField
      FieldName = 'DEPTNO'
    end
  end
  object LookupQuery: TMyQuery
    Connection = MyDACForm.MyConnection
    SQL.Strings = (
      'SELECT * FROM DEPT')
    Left = 304
    Top = 88
    object LookupQueryDEPTNO: TIntegerField
      FieldName = 'DEPTNO'
      Required = True
    end
    object LookupQueryDNAME: TStringField
      FieldName = 'DNAME'
      Size = 14
    end
    object LookupQueryLOC: TStringField
      FieldName = 'LOC'
      Size = 13
    end
  end
end