plsqltable.xfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

inherited PLSQLTableFrame: TPLSQLTableFrame
  HorzScrollBar.Range = 595
  VertScrollBar.Range = 174
  object Splitter1: TSplitter
    Left = 0
    Top = 171
    Width = 595
    Height = 3
    Cursor = crVSplit
    Align = alTop
    Beveled = True
    Color = 170
  end
  object ToolBar: TPanel
    Left = 0
    Top = 0
    Width = 595
    Height = 26
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 2
  end
  object Memo: TMemo
    Left = 0
    Top = 174
    Width = 595
    Height = 130
    Align = alClient
    ScrollBars = ssVertical
    TabOrder = 1
  end
  object gdDept: TDBGrid
    Left = 0
    Top = 26
    Width = 595
    Height = 145
    Align = alTop
    DataSource = dsDept
    TabOrder = 0
    TitleFont.Color = clBlack
    TitleFont.Height = 13
    TitleFont.Name = 'helvetica'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
  end
  object Panel1: TPanel
    Left = 1
    Top = 1
    Width = 594
    Height = 24
    BevelOuter = bvNone
    Color = 170
    TabOrder = 3
    object btOpen: TSpeedButton
      Left = 1
      Top = 1
      Width = 82
      Height = 22
      Caption = 'Open'
      Flat = True
      Transparent = False
      OnClick = btOpenClick
    end
    object btClose: TSpeedButton
      Left = 84
      Top = 1
      Width = 82
      Height = 22
      Caption = 'Close'
      Flat = True
      Transparent = False
      OnClick = btCloseClick
    end
    object btGet: TSpeedButton
      Left = 167
      Top = 1
      Width = 82
      Height = 22
      Caption = 'Get Names'
      Flat = True
      Font.Color = clText
      Font.Height = 9
      Font.Name = 'MS Sans Serif'
      Font.Pitch = fpVariable
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = False
      OnClick = btGetClick
    end
    object btPut: TSpeedButton
      Left = 250
      Top = 1
      Width = 82
      Height = 22
      Caption = 'Put Names'
      Flat = True
      Font.Color = clText
      Font.Height = 9
      Font.Name = 'MS Sans Serif'
      Font.Pitch = fpVariable
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = False
      OnClick = btPutClick
    end
    object DBNavigator: TDBNavigator
      Left = 333
      Top = 1
      Width = 260
      Height = 22
      DataSource = dsDept
      Flat = True
      TabOrder = 0
    end
  end
  object sqGet: TOraSQL
    Session = ODACForm.OraSession
    SQL.Strings = (
      'declare'
      '  i INTEGER;'
      'begin'
      '  i:= 1;'
      '  for Rec in (SELECT DName FROM Scott.Dept'
      '    WHERE RowNum <= 10 ORDER BY DeptNo)'
      '  loop'
      '    :NameArr(i):= Rec.DName;'
      '    i:= i + 1;'
      '  end loop;'
      'end;')
    Debug = True
    Left = 408
    Top = 32
    ParamData = <
      item
        DataType = ftString
        Name = 'NameArr'
        ParamType = ptInputOutput
        Size = 20
        Table = True
        Length = 10
      end>
  end
  object sqPut: TOraSQL
    Session = ODACForm.OraSession
    SQL.Strings = (
      'declare'
      '  i INTEGER;'
      'begin'
      '  i:= 1;'
      '  for Rec in (SELECT DeptNo FROM Scott.Dept'
      '    WHERE RowNum <= 10 ORDER BY DeptNo)'
      '  loop'
      '    UPDATE Scott.Dept'
      '      SET DName = :NameArr(i)'
      '      WHERE DeptNo = Rec.DeptNo;'
      '    i:= i + 1;'
      '  end loop;'
      'end;')
    Debug = True
    Left = 440
    Top = 32
    ParamData = <
      item
        DataType = ftString
        Name = 'NameArr'
        ParamType = ptInputOutput
        Size = 20
        Table = True
        Length = 10
      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')
    Session = ODACForm.OraSession
    SQL.Strings = (
      'SELECT * FROM Scott.Dept')
    Debug = True
    AutoCommit = False
    Left = 376
    Top = 64
  end
end