clob.lfm

Oracle Data Access Components Source Code ODAC v.6.70.0.45

object ClobFrame: TClobFrame
  Height = 341
  Width = 747
  object Splitter1: TSplitter
    Cursor = crVSplit
    Height = 2
    Top = 209
    Width = 747
    Align = alTop
    ResizeAnchor = akTop
  end
  object DBGrid: TDBGrid
    Height = 160
    Top = 49
    Width = 747
    Align = alTop
    DataSource = dsData
    FixedColor = clBtnFace
    FixedHotColor = cl3DLight
    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColumnMove, dgColLines, dgRowLines, dgTabs, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    OptionsExtra = [dgeAutoColumns, dgeCheckboxColumn]
    ParentColor = False
    TabOrder = 0
    TabStop = True
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
  end
  object ToolBar: TPanel
    Height = 49
    Width = 747
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 49
    ClientWidth = 747
    TabOrder = 1
    object Panel2: TPanel
      Left = 1
      Height = 47
      Top = 1
      Width = 424
      BevelOuter = bvNone
      ClientHeight = 47
      ClientWidth = 424
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btClose: TSpeedButton
        Left = 92
        Height = 22
        Top = 1
        Width = 90
        Caption = 'Close'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCloseClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Height = 22
        Top = 1
        Width = 90
        Caption = 'Open'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btOpenClick
      end
      object btCopyRecord2: TSpeedButton
        Left = 183
        Height = 22
        Top = 24
        Width = 90
        Caption = 'CopyRecord More'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCopyRecord2Click
      end
      object btCopyRecord1: TSpeedButton
        Left = 92
        Height = 22
        Top = 24
        Width = 90
        Caption = 'CopyRecord Alt'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCopyRecord1Click
      end
      object btCopyRecord: TSpeedButton
        Left = 1
        Height = 22
        Top = 24
        Width = 90
        Caption = 'CopyRecord'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btCopyRecordClick
      end
      object DBNavigator: TDBNavigator
        Left = 183
        Height = 22
        Top = 1
        Width = 240
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 240
        Color = clBtnFace
        DataSource = dsData
        Flat = True
        ParentColor = False
        TabOrder = 0
      end
      object Panel6: TPanel
        Left = 274
        Height = 22
        Top = 24
        Width = 149
        BevelOuter = bvNone
        ParentColor = False
        TabOrder = 1
      end
    end
  end
  object meComments: TDBMemo
    Height = 104
    Top = 237
    Width = 747
    Align = alClient
    DataField = 'VALUE'
    DataSource = dsData
    Lines.Strings = (
      'meComments'
    )
    ScrollBars = ssVertical
    TabOrder = 2
  end
  object ToolBar1: TPanel
    Height = 26
    Top = 211
    Width = 747
    Align = alTop
    BevelOuter = bvNone
    ClientHeight = 26
    ClientWidth = 747
    TabOrder = 3
    object Panel1: TPanel
      Left = 1
      Height = 24
      Top = 1
      Width = 666
      BevelOuter = bvNone
      ClientHeight = 24
      ClientWidth = 666
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btClear: TSpeedButton
        Left = 183
        Height = 22
        Top = 1
        Width = 90
        Caption = 'Clear'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btClearClick
      end
      object btSave: TSpeedButton
        Left = 92
        Height = 22
        Top = 1
        Width = 90
        Caption = 'Save to file'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btSaveClick
      end
      object btLoad: TSpeedButton
        Left = 1
        Height = 22
        Top = 1
        Width = 90
        Caption = 'Load from file'
        Color = clBtnFace
        Flat = True
        NumGlyphs = 0
        Transparent = False
        OnClick = btLoad1Click
      end
      object Panel3: TPanel
        Left = 274
        Height = 22
        Top = 1
        Width = 143
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 143
        ParentColor = False
        TabOrder = 0
        object cbDefLobRead: TCheckBox
          Left = 15
          Height = 19
          Width = 120
          Caption = 'Deferred LOB Read'
          OnClick = cbDefLobReadClick
          TabOrder = 0
        end
      end
      object Panel4: TPanel
        Left = 418
        Height = 22
        Top = 1
        Width = 95
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 95
        ParentColor = False
        TabOrder = 1
        object cbCacheLobs: TCheckBox
          Left = 8
          Height = 19
          Width = 83
          Caption = 'Cache Lobs'
          OnClick = cbCacheLobsClick
          TabOrder = 0
        end
      end
      object Panel5: TPanel
        Left = 514
        Height = 22
        Top = 1
        Width = 151
        BevelOuter = bvNone
        ClientHeight = 22
        ClientWidth = 151
        ParentColor = False
        TabOrder = 2
        object cbTemporaryLobUpdate: TCheckBox
          Left = 10
          Height = 19
          Width = 135
          Caption = 'Temporary Lob Update'
          OnClick = cbTemporaryLobUpdateClick
          TabOrder = 0
        end
      end
    end
  end
  object dsData: TDatasource
    DataSet = Query
    left = 440
    top = 56
  end
  object quInsertRecord: TOraQuery
    SQL.Strings = (
      'INSERT INTO ODAC_CLOB (Code,Title,Value)'
      '  VALUES (:Code, :Title, EMPTY_CLOB())'
      'RETURNING'
      '  Value'
      'INTO'
      '  :Value'
    )
    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 = 344
    top = 88
    ParamData = <    
      item
        DataType = ftInteger
        Name = 'Code'
        ParamType = ptInput
      end    
      item
        DataType = ftString
        Name = 'Title'
        ParamType = ptInput
      end    
      item
        DataType = ftOraClob
        Name = 'Value'
        ParamType = ptInput
      end>
  end
  object quCopyRecord: TOraQuery
    SQL.Strings = (
      'declare'
      '  Code NUMBER;'
      '  Title VARCHAR2(30);'
      '  Value CLOB;'
      'begin'
      '  SELECT Code,Title,Value'
      '  INTO Code,Title,Value'
      '  FROM ODAC_CLOB'
      '  WHERE RowId = :RowId;'
      ''
      '  INSERT INTO ODAC_CLOB (Code,Title,Value)'
      '    VALUES (Code, Title, Value);'
      'end;'
      '  '
    )
    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 = 312
    top = 120
    ParamData = <    
      item
        DataType = ftString
        Name = 'RowId'
        Size = 1999
      end>
  end
  object quSelectRecord: TOraQuery
    SQL.Strings = (
      'begin'
      '  SELECT Code,Title,Value'
      '  INTO :Code,:Title,:Value'
      '  FROM ODAC_CLOB'
      '  WHERE RowId = :RowId;'
      'end;'
      '  '
    )
    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 = 312
    top = 88
    ParamData = <    
      item
        DataType = ftInteger
        Name = 'Code'
        ParamType = ptOutput
      end    
      item
        DataType = ftString
        Name = 'Title'
        ParamType = ptOutput
        Size = 1999
      end    
      item
        DataType = ftOraClob
        Name = 'Value'
        ParamType = ptOutput
      end    
      item
        Name = 'RowId'
      end>
  end
  object Query: TOraQuery
    SQL.Strings = (
      'SELECT C.*, RowId FROM ODAC_CLOB C'
    )
    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 = 408
    top = 56
  end
  object OpenDialog: TOpenDialog
    Title = 'Open'
    InitialDir = '.'
    left = 240
    top = 259
  end
  object SaveDialog: TSaveDialog
    Title = 'Save As'
    InitialDir = '.'
    left = 272
    top = 259
  end
end