clob.xfm

ODAC 6 最新版的﹐網上找了好久才找到﹐不太好找啊﹐大家一起共享

inherited ClobFrame: TClobFrame
  Width = 726
  VertScrollBar.Range = 237
  object Splitter1: TSplitter
    Left = 0
    Top = 209
    Width = 726
    Height = 2
    Cursor = crVSplit
    Align = alTop
  end
  object DBGrid: TDBGrid
    Left = 0
    Top = 49
    Width = 726
    Height = 160
    Align = alTop
    DataSource = dsData
    TabOrder = 0
    TitleFont.Color = clBlack
    TitleFont.Height = 11
    TitleFont.Name = 'helvetica'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
  end
  object ToolBar: TPanel
    Left = 0
    Top = 0
    Width = 726
    Height = 49
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Panel2: TPanel
      Left = 1
      Top = 1
      Width = 424
      Height = 47
      BevelOuter = bvNone
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btClose: TSpeedButton
        Left = 92
        Top = 1
        Width = 90
        Height = 22
        Caption = 'Close'
        Flat = True
        Transparent = False
        OnClick = btCloseClick
      end
      object btOpen: TSpeedButton
        Left = 1
        Top = 1
        Width = 90
        Height = 22
        Caption = 'Open'
        Flat = True
        Transparent = False
        OnClick = btOpenClick
      end
      object btCopyRecord2: TSpeedButton
        Left = 183
        Top = 24
        Width = 90
        Height = 22
        Caption = 'CopyRecord More'
        Flat = True
        Transparent = False
        OnClick = btCopyRecord2Click
      end
      object btCopyRecord1: TSpeedButton
        Left = 92
        Top = 24
        Width = 90
        Height = 22
        Caption = 'CopyRecord Alt'
        Flat = True
        Transparent = False
        OnClick = btCopyRecord1Click
      end
      object btCopyRecord: TSpeedButton
        Left = 1
        Top = 24
        Width = 90
        Height = 22
        Caption = 'CopyRecord'
        Flat = True
        Transparent = False
        OnClick = btCopyRecordClick
      end
      object DBNavigator: TDBNavigator
        Left = 183
        Top = 1
        Width = 240
        Height = 22
        DataSource = dsData
        Flat = True
        TabOrder = 0
      end
      object Panel6: TPanel
        Left = 274
        Top = 24
        Width = 149
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 1
      end
    end
  end
  object meComments: TDBMemo
    Left = 0
    Top = 237
    Width = 726
    Height = 67
    Align = alClient
    DataField = 'VALUE'
    DataSource = dsData
    ScrollBars = ssVertical
    TabOrder = 2
  end
  object ToolBar1: TPanel
    Left = 0
    Top = 211
    Width = 726
    Height = 26
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 3
    object Panel1: TPanel
      Left = 1
      Top = 1
      Width = 666
      Height = 24
      BevelOuter = bvNone
      Color = 170
      ParentColor = False
      TabOrder = 0
      object btClear: TSpeedButton
        Left = 183
        Top = 1
        Width = 90
        Height = 22
        Caption = 'Clear'
        Flat = True
        Transparent = False
        OnClick = btClearClick
      end
      object btSave: TSpeedButton
        Left = 92
        Top = 1
        Width = 90
        Height = 22
        Caption = 'Save to file'
        Flat = True
        Transparent = False
        OnClick = btSaveClick
      end
      object btLoad: TSpeedButton
        Left = 1
        Top = 1
        Width = 90
        Height = 22
        Caption = 'Load from file'
        Flat = True
        Transparent = False
        OnClick = btLoad1Click
      end
      object Panel3: TPanel
        Left = 274
        Top = 1
        Width = 143
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 0
        object cbDefLobRead: TCheckBox
          Left = 15
          Top = 0
          Width = 120
          Height = 22
          Caption = 'Deferred LOB Read'
          Color = clButton
          ParentColor = False
          TabOrder = 0
          OnClick = cbDefLobReadClick
        end
      end
      object Panel4: TPanel
        Left = 418
        Top = 1
        Width = 95
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 1
        object cbCacheLobs: TCheckBox
          Left = 8
          Top = 0
          Width = 81
          Height = 22
          Caption = 'Cache Lobs'
          Color = clButton
          ParentColor = False
          TabOrder = 0
          OnClick = cbCacheLobsClick
        end
      end
      object Panel5: TPanel
        Left = 514
        Top = 1
        Width = 151
        Height = 22
        BevelOuter = bvNone
        Color = clButton
        ParentColor = False
        TabOrder = 2
        object cbTemporaryLobUpdate: TCheckBox
          Left = 10
          Top = 0
          Width = 135
          Height = 22
          Caption = 'Temporary Lob Update'
          Color = clButton
          ParentColor = False
          TabOrder = 0
          OnClick = cbTemporaryLobUpdateClick
        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
    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
    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
    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
        DataType = ftUnknown
        Name = 'RowId'
      end>
  end
  object Query: TOraQuery
    SQL.Strings = (
      'SELECT C.*, RowId FROM ODAC_CLOB C')
    Debug = True
    Left = 408
    Top = 56
  end
  object OpenDialog: TOpenDialog
    Height = 0
    Width = 0
    FilterIndex = 0
    InitialDir = '.'
    Title = 'Open'
    Left = 240
    Top = 259
  end
  object SaveDialog: TSaveDialog
    Height = 0
    Width = 0
    FilterIndex = 0
    InitialDir = '.'
    Title = 'Save As'
    Left = 272
    Top = 259
  end
end