query.xfm

ODAC 6 最新版的﹐網上找了好久才找到﹐不太好找啊﹐大家一起共享

inherited QueryFrame: TQueryFrame
  Width = 715
  VertScrollBar.Range = 143
  object Splitter1: TSplitter
    Left = 0
    Top = 115
    Width = 715
    Height = 3
    Cursor = crVSplit
    Align = alTop
    Beveled = True
  end
  object DBGrid: TDBGrid
    Left = 0
    Top = 143
    Width = 715
    Height = 161
    Align = alClient
    DataSource = DataSource
    Font.Color = clBlack
    Font.Height = 11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpVariable
    Font.Style = []
    ParentFont = False
    TabOrder = 1
    TitleFont.Color = clText
    TitleFont.Height = 11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
  end
  object meSQL: TMemo
    Left = 0
    Top = 24
    Width = 715
    Height = 91
    Align = alTop
    Font.Color = clBlack
    Font.Height = 11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpVariable
    Font.Style = []
    ParentFont = False
    ScrollBars = ssVertical
    TabOrder = 0
    OnExit = meSQLExit
  end
  object Panel4: TPanel
    Left = 0
    Top = 0
    Width = 715
    Height = 24
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 2
    object ToolBar: TPanel
      Left = 0
      Top = 0
      Width = 672
      Height = 24
      BevelOuter = bvNone
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btClose: TSpeedButton
        Left = 72
        Top = 1
        Width = 69
        Height = 22
        Caption = 'Close'
        Flat = True
        Transparent = False
        OnClick = btCloseClick
      end
      object btPrepare: TSpeedButton
        Left = 142
        Top = 1
        Width = 70
        Height = 22
        Caption = 'Prepare'
        Flat = True
        Transparent = False
        OnClick = btPrepareClick
      end
      object btUnPrepare: TSpeedButton
        Left = 213
        Top = 1
        Width = 70
        Height = 22
        Caption = 'UnPrepare'
        Flat = True
        Transparent = False
        OnClick = btUnPrepareClick
      end
      object btExecute: TSpeedButton
        Left = 284
        Top = 1
        Width = 69
        Height = 22
        Caption = 'Execute'
        Flat = True
        Transparent = False
        OnClick = btExecuteClick
      end
      object btBreak: TSpeedButton
        Left = 354
        Top = 1
        Width = 70
        Height = 22
        Caption = 'Break'
        Flat = True
        Transparent = False
        OnClick = btBreakClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Top = 1
        Width = 70
        Height = 22
        Caption = 'Open'
        Flat = True
        Transparent = False
        OnClick = btOpenClick
      end
      object btSaveToXML: TSpeedButton
        Left = 425
        Top = 1
        Width = 70
        Height = 22
        Caption = 'SaveToXML'
        Flat = True
        Transparent = False
        OnClick = btSaveToXMLClick
      end
      object Panel3: TPanel
        Left = 496
        Top = 1
        Width = 175
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 0
        object cbFetchAll: TCheckBox
          Left = 113
          Top = 4
          Width = 79
          Height = 16
          Caption = 'FetchAll'
          Color = clButton
          Font.Color = clBlack
          Font.Height = 11
          Font.Name = 'MS Sans Serif'
          Font.Pitch = fpVariable
          Font.Style = []
          ParentColor = False
          ParentFont = False
          TabOrder = 0
          OnClick = cbFetchAllClick
        end
        object cbNonBlocking: TCheckBox
          Left = 19
          Top = 4
          Width = 90
          Height = 16
          Caption = 'NonBlocking'
          TabOrder = 1
          OnClick = cbNonBlockingClick
        end
      end
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 118
    Width = 715
    Height = 25
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 3
    object Panel1: TPanel
      Left = 0
      Top = 0
      Width = 459
      Height = 24
      BevelOuter = bvNone
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btShowState: TSpeedButton
        Left = 388
        Top = 1
        Width = 70
        Height = 22
        Caption = 'ShowState'
        Flat = True
        Transparent = False
        OnClick = btShowStateClick
      end
      object btLock: TSpeedButton
        Left = 222
        Top = 1
        Width = 70
        Height = 22
        Caption = 'Lock'
        Flat = True
        Transparent = False
        OnClick = btLockClick
      end
      object btRefreshRecord: TSpeedButton
        Left = 293
        Top = 1
        Width = 94
        Height = 22
        Caption = 'RefreshRecord'
        Flat = True
        Transparent = False
        OnClick = btRefreshRecordClick
      end
      object DBNavigator1: TDBNavigator
        Left = 1
        Top = 1
        Width = 220
        Height = 22
        DataSource = DataSource
        Flat = True
        TabOrder = 0
      end
    end
  end
  object OraQuery: TOraQuery
    SQLInsert.Strings = (
      'INSERT INTO Scott.Dept'
      '  (DEPTNO, DNAME, LOC)'
      'VALUES'
      '  (:DEPTNO, :DNAME, :LOC)')
    SQLDelete.Strings = (
      'DELETE FROM Scott.Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO')
    SQLUpdate.Strings = (
      'UPDATE Scott.Dept'
      'SET'
      '  DEPTNO = :DEPTNO,'
      '  DNAME = :DNAME,'
      '  LOC = :LOC'
      'WHERE'
      '  DEPTNO = :OLD_DEPTNO')
    SQLLock.Strings = (
      'SELECT * FROM Scott.Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO'
      'FOR UPDATE NOWAIT')
    SQLRefresh.Strings = (
      'WHERE'
      '  D1.DEPTNO = :DEPTNO')
    SQL.Strings = (
      'SELECT D1.*,D2.DName'
      'FROM'
      '  Scott.Dept D1, Scott.Dept D2'
      'WHERE'
      '  D1.DeptNo = D2.DeptNo')
    Debug = True
    LockMode = lmLockImmediate
    RefreshOptions = [roAfterInsert, roAfterUpdate]
    AfterExecute = OraQueryAfterExecute
    Left = 408
    Top = 47
  end
  object DataSource: TDataSource
    DataSet = OraQuery
    Left = 440
    Top = 47
  end
  object SaveDialog: TSaveDialog
    DefaultExt = 'xml'
    Filter = 'XML (*.xml)|*.xml'
    Options = [ofOverwritePrompt, ofEnableSizing]
    Title = 'Save As'
    Left = 408
    Top = 88
  end
end