multicursors.nfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

inherited MultiCursorsFrame: TMultiCursorsFrame
  Width = 574
  Height = 353
  object Splitter1: TSplitter
    Left = 0
    Top = 222
    Width = 574
    Height = 3
    Cursor = crVSplit
    Align = alTop
    Beveled = True
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 26
    Width = 574
    Height = 196
    Align = alTop
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
  end
  object ToolBar: TPanel
    Left = 0
    Top = 0
    Width = 574
    Height = 26
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Panel2: TPanel
      Left = 1
      Top = 1
      Width = 408
      Height = 24
      BevelOuter = bvNone
      Color = 170
      TabOrder = 0
      object btClose: TSpeedButton
        Left = 84
        Top = 1
        Width = 82
        Height = 22
        Caption = 'Close'
        Flat = True
        Transparent = False
        OnClick = btCloseClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Top = 1
        Width = 82
        Height = 22
        Caption = 'Open'
        Flat = True
        Transparent = False
        OnClick = btOpenClick
      end
      object DBNavigator: TDBNavigator
        Left = 167
        Top = 1
        Width = 240
        Height = 22
        DataSource = DataSource1
        Flat = True
        TabOrder = 0
      end
    end
  end
  object DBGrid2: TDBGrid
    Left = 0
    Top = 225
    Width = 574
    Height = 128
    Align = alClient
    DataSource = DataSource2
    TabOrder = 2
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 408
    Top = 64
  end
  object Query1: 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 = (
      'begin'
      '  OPEN :Cur1 FOR'
      '    SELECT D.*, D.RowId'
      '    FROM Scott.Dept D'
      '    ORDER BY DeptNo;'
      '  OPEN :Cur2 FOR'
      '    SELECT D.*, D.RowId'
      '    FROM Scott.Emp D'
      '    ORDER BY EmpNo;'
      'end;')
    Debug = True
    Left = 408
    Top = 32
    ParamData = <
      item
        DataType = ftCursor
        Name = 'Cur1'
        ParamType = ptOutput
      end
      item
        DataType = ftCursor
        Name = 'Cur2'
        ParamType = ptOutput
      end>
  end
  object DataSource2: TDataSource
    DataSet = Query2
    Left = 448
    Top = 64
  end
  object Query2: TSmartQuery
    UpdatingTable = 'SCOTT.EMP'
    Session = ODACForm.OraSession
    SQL.Strings = (
      'SELECT T.*, T.RowId FROM Scott.Emp T')
    Debug = True
    LockMode = lmNone
    Left = 448
    Top = 32
  end
end