cursor.nfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

inherited CursorFrame: TCursorFrame
  object DBGrid: TDBGrid
    Left = 0
    Top = 26
    Width = 443
    Height = 251
    Align = alClient
    DataSource = DataSource
    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 = 443
    Height = 26
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Panel1: TPanel
      Left = 1
      Top = 1
      Width = 491
      Height = 24
      BevelOuter = bvNone
      Color = 170
      TabOrder = 0
      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 btGetCursor: TSpeedButton
        Left = 408
        Top = 1
        Width = 82
        Height = 22
        Caption = 'GetCursor'
        Flat = True
        Transparent = False
        OnClick = btGetCursorClick
      end
      object DBNavigator: TDBNavigator
        Left = 167
        Top = 1
        Width = 240
        Height = 22
        DataSource = DataSource
        Flat = True
        TabOrder = 0
      end
    end
  end
  object DataSource: TDataSource
    DataSet = Query
    Left = 440
    Top = 32
  end
  object Query: 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 :Cur FOR'
      '    SELECT D.*, D.RowId'
      '    FROM Scott.Dept D'
      '    ORDER BY DeptNo;'
      'end;')
    Debug = True
    FetchRows = 1
    Left = 408
    Top = 32
    ParamData = <
      item
        DataType = ftCursor
        Name = 'Cur'
      end>
  end
  object OraSQL: TOraSQL
    Session = ODACForm.OraSession
    SQL.Strings = (
      'begin'
      '  OPEN :Cur FOR'
      '    SELECT D.*, D.RowId, '#39'This is cursor'#39' Info'
      '    FROM Scott.Dept D'
      '    ORDER BY DeptNo;'
      'end;')
    Debug = True
    Left = 480
    Top = 32
    ParamData = <
      item
        DataType = ftCursor
        Name = 'Cur'
      end>
  end
end