query.lfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

inherited QueryFrame: TQueryFrame
  Width = 812
  object Splitter1: TSplitter
    Cursor = crVSplit
    Height = 3
    Top = 115
    Width = 812
    Align = alTop
    Beveled = True
    ResizeAnchor = akTop
  end
  object DBGrid: TDBGrid
    Height = 133
    Top = 143
    Width = 812
    Align = alClient
    DataSource = DataSource
    FixedColor = clBtnFace
    FixedHotColor = cl3DLight
    Font.Color = clBlack
    Font.Height = -11
    Font.Name = 'Tahoma'
    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    OptionsExtra = [dgeAutoColumns, dgeCheckboxColumn]
    ParentColor = False
    TabOrder = 1
    TabStop = True
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
  end
  object meSQL: TMemo
    Height = 91
    Top = 24
    Width = 812
    Align = alTop
    Font.Color = clBlack
    Font.Height = -11
    Font.Name = 'Tahoma'
    OnExit = meSQLExit
    ScrollBars = ssVertical
    TabOrder = 0
  end
  object Panel4: TPanel
    Height = 24
    Width = 812
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 24
    ClientWidth = 812
    TabOrder = 2
    object ToolBar: TPanel
      Height = 24
      Width = 672
      BevelOuter = bvNone
      ClientHeight = 24
      ClientWidth = 672
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btClose: TSpeedButton
        Left = 72
        Height = 22
        Top = 1
        Width = 69
        Caption = 'Close'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCloseClick
      end
      object btPrepare: TSpeedButton
        Left = 142
        Height = 22
        Top = 1
        Width = 70
        Caption = 'Prepare'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btPrepareClick
      end
      object btUnPrepare: TSpeedButton
        Left = 213
        Height = 22
        Top = 1
        Width = 70
        Caption = 'UnPrepare'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btUnPrepareClick
      end
      object btExecute: TSpeedButton
        Left = 284
        Height = 22
        Top = 1
        Width = 69
        Caption = 'Execute'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btExecuteClick
      end
      object btBreak: TSpeedButton
        Left = 354
        Height = 22
        Top = 1
        Width = 70
        Caption = 'Break'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btBreakClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Height = 22
        Top = 1
        Width = 70
        Caption = 'Open'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btOpenClick
      end
      object btSaveToXML: TSpeedButton
        Left = 425
        Height = 22
        Top = 1
        Width = 70
        Caption = 'SaveToXML'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btSaveToXMLClick
      end
      object Panel3: TPanel
        Left = 496
        Height = 22
        Top = 1
        Width = 175
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 175
        ParentColor = False
        TabOrder = 0
        object cbFetchAll: TCheckBox
          Left = 113
          Height = 19
          Top = 4
          Width = 64
          Caption = 'FetchAll'
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Tahoma'
          OnClick = cbFetchAllClick
          TabOrder = 0
        end
        object cbNonBlocking: TCheckBox
          Left = 19
          Height = 19
          Top = 4
          Width = 87
          Caption = 'NonBlocking'
          OnClick = cbNonBlockingClick
          TabOrder = 1
        end
      end
    end
  end
  object Panel2: TPanel
    Height = 25
    Top = 118
    Width = 812
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 25
    ClientWidth = 812
    TabOrder = 3
    object Panel1: TPanel
      Height = 24
      Width = 459
      BevelOuter = bvNone
      ClientHeight = 24
      ClientWidth = 459
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btShowState: TSpeedButton
        Left = 388
        Height = 22
        Top = 1
        Width = 70
        Caption = 'ShowState'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btShowStateClick
      end
      object btLock: TSpeedButton
        Left = 222
        Height = 22
        Top = 1
        Width = 70
        Caption = 'Lock'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btLockClick
      end
      object btRefreshRecord: TSpeedButton
        Left = 293
        Height = 22
        Top = 1
        Width = 94
        Caption = 'RefreshRecord'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btRefreshRecordClick
      end
      object DBNavigator1: TDBNavigator
        Left = 1
        Height = 22
        Top = 1
        Width = 220
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 220
        Color = clBtnFace
        DataSource = DataSource
        Flat = True
        ParentColor = False
        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]
    Options.AutoClose = False
    Options.FieldsAsString = False
    Options.DeferredLobRead = False
    Options.ScrollableCursor = False
    Options.FieldsOrigin = False
    Options.DefaultValues = False
    Options.NumberRange = False
    Options.QueryRecCount = False
    Options.AutoPrepare = False
    Options.ReturnParams = False
    Options.FlatBuffers = False
    Options.DetailDelay = 0
    AfterExecute = OraQueryAfterExecute
    left = 408
    top = 47
  end
  object DataSource: TDatasource
    DataSet = OraQuery
    left = 440
    top = 47
  end
  object SaveDialog: TSaveDialog
    Title = '杨躔囗栩