updatesql.lfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

inherited UpdateSQLFrame: TUpdateSQLFrame
  Height = 293
  Width = 679
  object Splitter1: TSplitter
    Cursor = crVSplit
    Height = 3
    Top = 119
    Width = 679
    Align = alTop
    Beveled = True
    Color = 170
    ParentColor = False
    ResizeAnchor = akTop
  end
  object DBGrid: TDBGrid
    Height = 147
    Top = 146
    Width = 679
    Align = alClient
    DataSource = DataSource
    FixedColor = clBtnFace
    FixedHotColor = cl3DLight
    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    OptionsExtra = [dgeAutoColumns, dgeCheckboxColumn]
    ParentColor = False
    TabOrder = 0
    TabStop = True
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
  end
  object meSQL: TMemo
    Height = 72
    Top = 47
    Width = 679
    Align = alTop
    Constraints.MinHeight = 50
    OnExit = meSQLExit
    ScrollBars = ssVertical
    TabOrder = 1
  end
  object Panel3: TPanel
    Height = 24
    Top = 122
    Width = 679
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 24
    ClientWidth = 679
    TabOrder = 2
    object Panel1: TPanel
      Height = 24
      Width = 317
      BevelOuter = bvNone
      ClientHeight = 24
      ClientWidth = 317
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btRefreshRecord: TSpeedButton
        Left = 231
        Height = 22
        Top = 1
        Width = 85
        Caption = 'RefreshRecord'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btRefreshRecordClick
      end
      object DBNavigator1: TDBNavigator
        Height = 22
        Top = 1
        Width = 230
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 230
        Color = clBtnFace
        DataSource = DataSource
        Flat = True
        ParentColor = False
        TabOrder = 0
      end
    end
  end
  object Panel6: TPanel
    Height = 47
    Width = 679
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 47
    ClientWidth = 679
    TabOrder = 3
    object ToolBar: TPanel
      Height = 47
      Width = 634
      Align = alLeft
      BevelOuter = bvNone
      ClientHeight = 47
      ClientWidth = 634
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btBreak: TSpeedButton
        Left = 431
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Break'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btBreakClick
      end
      object btUnPrepare: TSpeedButton
        Left = 259
        Height = 22
        Top = 1
        Width = 85
        Caption = 'UnPrepare'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btUnPrepareClick
      end
      object btPrepare: TSpeedButton
        Left = 173
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Prepare'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btPrepareClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Open'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btOpenClick
      end
      object btExecute: TSpeedButton
        Left = 345
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Execute'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btExecuteClick
      end
      object btClose: TSpeedButton
        Left = 87
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Close'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCloseClick
      end
      object Panel2: TPanel
        Left = 517
        Height = 22
        Top = 1
        Width = 116
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 116
        ParentColor = False
        TabOrder = 0
        object cbNonBlocking: TCheckBox
          Left = 8
          Height = 19
          Top = 3
          Width = 87
          Caption = 'NonBlocking'
          OnClick = cbNonBlockingClick
          ParentColor = False
          TabOrder = 0
        end
      end
      object Panel4: TPanel
        Left = 1
        Height = 22
        Top = 24
        Width = 632
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 632
        ParentColor = False
        TabOrder = 1
        object cbDeleteObject: TCheckBox
          Left = 14
          Height = 19
          Top = 3
          Width = 88
          Caption = 'DeleteObject'
          OnClick = cbObjectClick
          ParentColor = False
          TabOrder = 0
        end
        object cbInsertObject: TCheckBox
          Left = 112
          Height = 19
          Top = 3
          Width = 83
          Caption = 'InsertObject'
          OnClick = cbObjectClick
          ParentColor = False
          TabOrder = 1
        end
        object cbModifyObject: TCheckBox
          Left = 206
          Height = 19
          Top = 3
          Width = 88
          Caption = 'ModifyObject'
          OnClick = cbObjectClick
          ParentColor = False
          TabOrder = 2
        end
        object cbRefreshObject: TCheckBox
          Left = 298
          Height = 19
          Top = 3
          Width = 94
          Caption = 'RefreshObject'
          OnClick = cbObjectClick
          ParentColor = False
          TabOrder = 3
        end
      end
    end
  end
  object OraQuery: TOraQuery
    SQL.Strings = (
      'SELECT * FROM Dept'
      ''
    )
    Debug = True
    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
    UpdateObject = OraUpdateSQL
    left = 24
    top = 200
  end
  object DataSource: TDatasource
    DataSet = OraQuery
    left = 24
    top = 232
  end
  object OraUpdateSQL: TOraUpdateSQL
    InsertSQL.Strings = (
      'INSERT INTO Dept'
      '  (DEPTNO, DNAME, LOC)'
      'VALUES'
      '  (:DEPTNO, :DNAME, :LOC)'
    )
    DeleteSQL.Strings = (
      'DELETE FROM Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO'
    )
    ModifySQL.Strings = (
      'UPDATE Dept'
      'SET'
      '  DEPTNO = :DEPTNO,'
      '  DNAME = :DNAME,'
      '  LOC = :LOC'
      'WHERE'
      '  DEPTNO = :OLD_DEPTNO'
    )
    RefreshSQL.Strings = (
      'SELECT * FROM Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO'
    )
    left = 56
    top = 200
  end
  object DeleteSQL: TOraSQL
    SQL.Strings = (
      'DELETE FROM Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO'
    )
    left = 96
    top = 160
    ParamData = <    
      item
        Name = 'DEPTNO'
      end>
  end
  object InsertSQL: TOraSQL
    SQL.Strings = (
      'INSERT INTO Dept'
      '  (DEPTNO, DNAME, LOC)'
      'VALUES'
      '  (:DEPTNO, :DNAME, :LOC)'
      ''
    )
    left = 96
    top = 192
    ParamData = <    
      item
        Name = 'DEPTNO'
      end    
      item
        Name = 'DNAME'
      end    
      item
        Name = 'LOC'
      end>
  end
  object RefreshQuery: TOraQuery
    SQL.Strings = (
      'SELECT * FROM Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO'
    )
    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
    left = 96
    top = 256
    ParamData = <    
      item
        Name = 'DEPTNO'
      end>
  end
  object ModifyQuery: TOraQuery
    SQL.Strings = (
      'UPDATE Dept'
      'SET'
      '  DEPTNO = :DEPTNO,'
      '  DNAME = :DNAME,'
      '  LOC = :LOC'
      'WHERE'
      '  DEPTNO = :OLD_DEPTNO'
    )
    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
    left = 96
    top = 224
    ParamData = <    
      item
        Name = 'DEPTNO'
      end    
      item
        Name = 'DNAME'
      end    
      item
        Name = 'LOC'
      end    
      item
        Name = 'OLD_DEPTNO'
      end>
  end
end