dmlarray.lfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

object DMLArrayFrame: TDMLArrayFrame
  Height = 332
  Width = 647
  object Splitter1: TSplitter
    Cursor = crVSplit
    Height = 3
    Top = 170
    Width = 647
    Align = alTop
    Beveled = True
    Color = 170
    ParentColor = False
    ResizeAnchor = akTop
  end
  object ToolBar: TPanel
    Height = 26
    Width = 647
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 26
    ClientWidth = 647
    TabOrder = 4
    object Panel2: TPanel
      Left = 1
      Height = 24
      Top = 1
      Width = 574
      BevelOuter = bvNone
      ClientHeight = 24
      ClientWidth = 574
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btPut: TSpeedButton
        Left = 250
        Height = 22
        Top = 1
        Width = 82
        Caption = 'Put Names'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btPutClick
        ParentFont = True
      end
      object btGet: TSpeedButton
        Left = 167
        Height = 22
        Top = 1
        Width = 82
        Caption = 'Get Names'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btGetClick
      end
      object btClose: TSpeedButton
        Left = 84
        Height = 22
        Top = 1
        Width = 82
        Caption = 'Close'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCloseClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Height = 22
        Top = 1
        Width = 82
        Caption = 'Open'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btOpenClick
      end
      object DBNavigator: TDBNavigator
        Left = 333
        Height = 22
        Top = 1
        Width = 240
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 240
        Color = clBtnFace
        DataSource = dsDept
        Flat = True
        ParentColor = False
        TabOrder = 0
      end
    end
  end
  object Memo: TMemo
    Left = 61
    Height = 140
    Top = 192
    Width = 586
    Align = alClient
    ScrollBars = ssVertical
    TabOrder = 1
  end
  object gdDept: TDBGrid
    Height = 144
    Top = 26
    Width = 647
    Align = alTop
    DataSource = dsDept
    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 Memo1: TMemo
    Height = 140
    Top = 192
    Width = 61
    Align = alLeft
    ReadOnly = True
    TabOrder = 2
  end
  object Panel1: TPanel
    Height = 19
    Top = 173
    Width = 647
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 19
    ClientWidth = 647
    TabOrder = 3
    object Label1: TLabel
      Left = 66
      Height = 14
      Top = 2
      Width = 36
      Caption = 'DNAME'
      ParentColor = False
    end
    object Label2: TLabel
      Left = 4
      Height = 14
      Top = 2
      Width = 41
      Caption = 'DEPTNO'
      ParentColor = False
    end
  end
  object sqGet: TOraSQL
    SQL.Strings = (
      'begin'
      '  SELECT *'
      '  INTO :DeptNo, :DName, :RowNum'
      '  FROM '
      '    (SELECT DeptNo,DName,RowNum RowNo'
      '    FROM Scott.Dept)'
      '  WHERE'
      '    RowNo = :RowNum;'
      'end;'
    )
    Debug = True
    left = 408
    top = 32
    ParamData = <    
      item
        DataType = ftInteger
        Name = 'DeptNo'
      end    
      item
        DataType = ftString
        Name = 'DName'
        Size = 50
      end    
      item
        DataType = ftInteger
        Name = 'RowNum'
      end>
  end
  object sqPut: TOraSQL
    SQL.Strings = (
      'UPDATE Scott.Dept'
      'SET DName = :DName'
      'WHERE DeptNo = :DeptNo'
      ''
      ''
    )
    Debug = True
    left = 440
    top = 32
    ParamData = <    
      item
        DataType = ftString
        Name = 'DName'
        Size = 1999
      end    
      item
        DataType = ftInteger
        Name = 'DeptNo'
      end>
  end
  object dsDept: TDatasource
    DataSet = quDept
    left = 408
    top = 64
  end
  object quDept: 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'
    )
    SQL.Strings = (
      'SELECT * FROM Scott.Dept'
    )
    Debug = True
    AutoCommit = False
    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 = 376
    top = 64
  end
end