main.dfm

Delphi7数据库开发教程,包含该书21套实例

object Form1: TForm1
  Left = -1
  Top = 11
  Width = 800
  Height = 564
  Caption = 'Form1'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object DecisionPivot1: TDecisionPivot
    Left = 8
    Top = 8
    Width = 505
    Height = 33
    ButtonAutoSize = True
    DecisionSource = DecisionSource1
    GroupLayout = xtHorizontal
    Groups = [xtRows, xtColumns, xtSummaries]
    ButtonSpacing = 0
    ButtonWidth = 64
    ButtonHeight = 24
    GroupSpacing = 10
    BorderWidth = 0
    BorderStyle = bsNone
    TabOrder = 0
  end
  object PageControl1: TPageControl
    Left = 8
    Top = 48
    Width = 777
    Height = 473
    ActivePage = TabSheet2
    TabOrder = 1
    object TabSheet1: TTabSheet
      Caption = #34920#26684
      object DecisionGrid1: TDecisionGrid
        Left = 6
        Top = 5
        Width = 755
        Height = 436
        DefaultColWidth = 100
        DefaultRowHeight = 20
        CaptionColor = clActiveCaption
        CaptionFont.Charset = DEFAULT_CHARSET
        CaptionFont.Color = clCaptionText
        CaptionFont.Height = -11
        CaptionFont.Name = 'MS Sans Serif'
        CaptionFont.Style = []
        DataColor = clInfoBk
        DataSumColor = clNone
        DataFont.Charset = DEFAULT_CHARSET
        DataFont.Color = clWindowText
        DataFont.Height = -11
        DataFont.Name = 'MS Sans Serif'
        DataFont.Style = []
        LabelFont.Charset = DEFAULT_CHARSET
        LabelFont.Color = clWindowText
        LabelFont.Height = -11
        LabelFont.Name = 'MS Sans Serif'
        LabelFont.Style = []
        LabelColor = clBtnFace
        LabelSumColor = clInactiveCaption
        DecisionSource = DecisionSource1
        Dimensions = <
          item
            FieldName = #21160#29289#21517#23383
            Color = clNone
            Alignment = taCenter
            Subtotals = True
          end
          item
            FieldName = #22320#21306
            Color = clNone
            Alignment = taCenter
            Subtotals = True
          end
          item
            FieldName = #23610#23544#21644
            Color = clNone
            Alignment = taCenter
            Subtotals = True
          end
          item
            FieldName = #37325#37327#21644
            Color = clNone
            Alignment = taCenter
            Subtotals = True
          end>
        Totals = True
        ShowCubeEditor = False
        Color = clBtnFace
        GridLineWidth = 1
        GridLineColor = clWindowText
        TabOrder = 0
      end
    end
    object TabSheet2: TTabSheet
      Caption = #22270#24418
      ImageIndex = 1
      object DecisionGraph1: TDecisionGraph
        Left = 4
        Top = -1
        Width = 760
        Height = 446
        DecisionSource = DecisionSource1
        Title.Text.Strings = (
          'TDecisionGraph')
        BottomAxis.Title.Caption = #21160#29289#21517#23383
        LeftAxis.Title.Caption = #37325#37327#21644
        RightAxis.Title.Caption = #37325#37327#21644
        TopAxis.Title.Caption = #21160#29289#21517#23383
        TabOrder = 0
        object Series9: TBarSeries
          Active = False
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clRed
          Title = 'Template: '#21160#29289#21517#23383
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'Template: '#21160#29289#21517#23383
          Style = 61
        end
        object Series3: TBarSeries
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clRed
          Title = 'Africa and Asia'
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'Africa and Asia'
          Style = 40
        end
        object Series4: TBarSeries
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clGreen
          Title = 'Computer Aquariums'
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'Computer Aquariums'
          Style = 40
        end
        object Series5: TBarSeries
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clYellow
          Title = 'Fish Bowls'
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'Fish Bowls'
          Style = 40
        end
        object Series6: TBarSeries
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clBlue
          Title = 'New Orleans'
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'New Orleans'
          Style = 40
        end
        object Series7: TBarSeries
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clWhite
          Title = 'Screen Savers'
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'Screen Savers'
          Style = 40
        end
        object Series8: TBarSeries
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clGray
          Title = 'South America'
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'South America'
          Style = 40
        end
        object Series1: TBarSeries
          Active = False
          Marks.ArrowLength = 20
          Marks.Visible = False
          SeriesColor = clRed
          Title = 'Template: '#22320#21306
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1.000000000000000000
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1.000000000000000000
          YValues.Order = loNone
          Identifier = 'Template: '#22320#21306
          Style = 61
        end
      end
    end
  end
  object btnShowCubeDialog: TButton
    Left = 528
    Top = 8
    Width = 75
    Height = 25
    Caption = #35774#23450#21442#25968
    TabOrder = 2
    OnClick = btnShowCubeDialogClick
  end
  object cbxShowLegend: TCheckBox
    Left = 616
    Top = 16
    Width = 97
    Height = 17
    Caption = #26174#31034#22270#20363
    Checked = True
    State = cbChecked
    TabOrder = 3
    OnClick = cbxShowLegendClick
  end
  object DecisionCube1: TDecisionCube
    DataSet = DecisionQuery1
    DimensionMap = <
      item
        ActiveFlag = diAsNeeded
        FieldType = ftString
        Fieldname = 'NAME'
        BaseName = '"animals.dbf".NAME'
        Name = #21160#29289#21517#23383
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 7
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftString
        Fieldname = 'AREA'
        BaseName = '"animals.dbf".AREA'
        Name = #22320#21306
        DerivedFrom = -1
        DimensionType = dimDimension
        BinType = binNone
        ValueCount = 6
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'SUM OF SIZE'
        BaseName = '"animals.dbf"."SIZE"'
        Name = #23610#23544#21644
        DerivedFrom = -1
        DimensionType = dimSum
        BinType = binNone
        ValueCount = -1
        Active = True
      end
      item
        ActiveFlag = diAsNeeded
        FieldType = ftFloat
        Fieldname = 'SUM OF WEIGHT'
        BaseName = '"animals.dbf".WEIGHT'
        Name = #37325#37327#21644
        DerivedFrom = -1
        DimensionType = dimSum
        BinType = binNone
        ValueCount = -1
        Active = True
      end>
    ShowProgressDialog = True
    MaxDimensions = 5
    MaxSummaries = 10
    MaxCells = 0
    Left = 696
    Top = 8
  end
  object DecisionQuery1: TDecisionQuery
    Active = True
    DatabaseName = 'DBDEMOS'
    SQL.Strings = (
      'SELECT NAME, AREA, SUM( "animals.dbf"."SIZE" ), SUM( WEIGHT )'
      'FROM "animals.dbf"'
      'GROUP BY NAME, AREA')
    Left = 728
    Top = 8
  end
  object DecisionSource1: TDecisionSource
    DecisionCube = DecisionCube1
    ControlType = xtCheck
    SparseRows = False
    SparseCols = False
    Left = 760
    Top = 8
    DimensionCount = 2
    SummaryCount = 2
    CurrentSummary = 1
    SparseRows = False
    SparseCols = False
    DimensionInfo = (
      2
      0
      1
      0
      0
      1
      0
      1
      0
      -1)
  end
end