fetchcursors.xfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

inherited FetchCursorsFrame: TFetchCursorsFrame
  object Splitter1: TSplitter
    Left = 0
    Top = 189
    Width = 443
    Height = 3
    Cursor = crVSplit
    Align = alTop
    Beveled = True
    Color = 170
    ParentColor = False
  end
  object DBGrid: TDBGrid
    Left = 0
    Top = 26
    Width = 443
    Height = 163
    Align = alTop
    DataSource = DataSource
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    OnDrawDataCell = DBGridDrawDataCell
  end
  object ToolBar: TPanel
    Left = 0
    Top = 0
    Width = 443
    Height = 26
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Panel1: TPanel
      Left = 1
      Top = 0
      Width = 493
      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 btRefresh: TSpeedButton
        Left = 408
        Top = 1
        Width = 84
        Height = 22
        Caption = 'Refresh'
        Flat = True
        Transparent = False
        OnClick = btRefreshClick
      end
      object DBNavigator: TDBNavigator
        Left = 167
        Top = 1
        Width = 240
        Height = 22
        DataSource = DataSource
        Flat = True
        TabOrder = 0
      end
    end
  end
  object ToolBar1: TPanel
    Left = 0
    Top = 192
    Width = 443
    Height = 26
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 2
    object Panel2: TPanel
      Left = 1
      Top = 1
      Width = 408
      Height = 24
      BevelOuter = bvNone
      Color = 170
      TabOrder = 0
      object btClose1: TSpeedButton
        Left = 84
        Top = 1
        Width = 82
        Height = 22
        Caption = 'Close'
        Flat = True
        Transparent = False
        OnClick = btClose1Click
      end
      object brGetCursor: TSpeedButton
        Left = 1
        Top = 1
        Width = 82
        Height = 22
        Caption = 'GetCursor'
        Flat = True
        Transparent = False
        OnClick = brGetCursorClick
      end
      object DBNavigator1: TDBNavigator
        Left = 167
        Top = 1
        Width = 240
        Height = 22
        DataSource = DataSource1
        Flat = True
        TabOrder = 0
      end
    end
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 218
    Width = 443
    Height = 59
    Align = alClient
    DataSource = DataSource1
    TabOrder = 3
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object Query: TOraQuery
    SQLInsert.Strings = (
      'INSERT INTO Dept'
      '  (DEPTNO, DNAME, LOC)'
      'VALUES'
      '  (:DEPTNO, :DNAME, :LOC)')
    SQLDelete.Strings = (
      'DELETE FROM Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO')
    SQLUpdate.Strings = (
      'UPDATE Dept'
      'SET'
      '  DEPTNO = :DEPTNO,'
      '  DNAME = :DNAME,'
      '  LOC = :LOC'
      'WHERE'
      '  DEPTNO = :OLD_DEPTNO')
    Session = ODACForm.OraSession
    SQL.Strings = (
      'SELECT'
      '  D.*,'
      '  CURSOR(SELECT * FROM Emp WHERE DeptNo = D.DeptNo) Emps'
      'FROM'
      '  Dept D')
    Debug = True
    FetchRows = 2
    Left = 376
    Top = 32
    object QueryDEPTNO: TIntegerField
      FieldName = 'DEPTNO'
      Required = True
    end
    object QueryDNAME: TStringField
      FieldName = 'DNAME'
      Size = 14
    end
    object QueryLOC: TStringField
      FieldName = 'LOC'
      Size = 13
    end
    object QueryEMPS: TCursorField
      FieldName = 'EMPS'
    end
  end
  object DataSource: TDataSource
    DataSet = Query
    Left = 408
    Top = 32
  end
  object OraQuery1: TOraQuery
    SQLInsert.Strings = (
      'INSERT INTO Emp'
      '  (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)'
      'VALUES'
      '  (:EMPNO, :ENAME, :JOB, :MGR, :HIREDATE, :SAL, :COMM, :DEPTNO)')
    SQLDelete.Strings = (
      'DELETE FROM Emp'
      'WHERE'
      '  EMPNO = :EMPNO')
    SQLUpdate.Strings = (
      'UPDATE Emp'
      'SET'
      '  EMPNO = :EMPNO,'
      '  ENAME = :ENAME,'
      '  JOB = :JOB,'
      '  MGR = :MGR,'
      '  HIREDATE = :HIREDATE,'
      '  SAL = :SAL,'
      '  COMM = :COMM,'
      '  DEPTNO = :DEPTNO'
      'WHERE'
      '  EMPNO = :OLD_EMPNO')
    Session = ODACForm.OraSession
    Debug = True
    FetchRows = 1
    Left = 376
    Top = 216
  end
  object DataSource1: TDataSource
    DataSet = OraQuery1
    Left = 408
    Top = 216
  end
  object OraSQL: TOraSQL
    Session = ODACForm.OraSession
    Debug = True
    Left = 464
    Top = 32
  end
end