storedproc.lfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

inherited StoredProcFrame: TStoredProcFrame
  Width = 677
  object DBGrid: TDBGrid
    Height = 228
    Top = 48
    Width = 677
    Align = alClient
    DataSource = DataSource
    FixedColor = clBtnFace
    FixedHotColor = cl3DLight
    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    OptionsExtra = [dgeAutoColumns, dgeCheckboxColumn]
    ParentColor = False
    TabOrder = 1
    TabStop = True
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
  end
  object ToolBar: TPanel
    Height = 48
    Width = 677
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 48
    ClientWidth = 677
    TabOrder = 0
    object Panel1: TPanel
      Left = 1
      Height = 24
      Width = 517
      BevelOuter = bvNone
      ClientHeight = 24
      ClientWidth = 517
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btOpen: TSpeedButton
        Left = 1
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Open'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btOpenClick
      end
      object btClose: TSpeedButton
        Left = 87
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Close'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCloseClick
      end
      object btPrepare: TSpeedButton
        Left = 173
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Prepare'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btPrepareClick
      end
      object btUnPrepare: TSpeedButton
        Left = 259
        Height = 22
        Top = 1
        Width = 85
        Caption = 'UnPrepare'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btUnPrepareClick
      end
      object btExecute: TSpeedButton
        Left = 345
        Height = 22
        Top = 1
        Width = 85
        Caption = 'Execute'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btExecuteClick
      end
      object btPrepareSQL: TSpeedButton
        Left = 431
        Height = 22
        Top = 1
        Width = 85
        Caption = 'PrepareSQL'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btPrepareSQLClick
      end
    end
    object Panel2: TPanel
      Left = 1
      Height = 24
      Top = 23
      Width = 517
      BevelOuter = bvNone
      ClientHeight = 24
      ClientWidth = 517
      Color = 170
      ParentColor = False
      TabOrder = 1
      object DBNavigator: TDBNavigator
        Left = 296
        Height = 22
        Top = 1
        Width = 220
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 220
        Color = clBtnFace
        DataSource = DataSource
        Flat = True
        ParentColor = False
        TabOrder = 0
      end
      object Panel3: TPanel
        Left = 1
        Height = 22
        Top = 1
        Width = 294
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 294
        ParentColor = False
        TabOrder = 1
        object Label1: TLabel
          Left = 4
          Height = 13
          Top = 6
          Width = 82
          Caption = 'StoredProc name'
          ParentColor = False
        end
        object edStoredProcName: TEdit
          Left = 95
          Height = 21
          Top = 1
          Width = 181
          TabOrder = 0
        end
      end
    end
  end
  object DataSource: TDatasource
    DataSet = OraStoredProc
    left = 432
    top = 72
  end
  object OraStoredProc: TOraStoredProc
    StoredProcName = 'scott.ODACPACK.GETDEPTFUNC'
    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'
    )
    SQLRefresh.Strings = (
      'WHERE'
      '  DEPTNO = :DEPTNO'
    )
    Debug = True
    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 = 400
    top = 72
  end
end