clob.lrs

Oracle Data Access Components Source Code ODAC v.6.70.0.45

LazarusResources.Add('TClobFrame','FORMDATA',[
  'TPF0'#10'TClobFrame'#9'ClobFrame'#6'Height'#3'U'#1#5'Width'#3#235#2#0#9'TSpl'
  +'itter'#9'Splitter1'#6'Cursor'#7#8'crVSplit'#6'Height'#2#2#3'Top'#3#209#0#5
  +'Width'#3#235#2#5'Align'#7#5'alTop'#12'ResizeAnchor'#7#5'akTop'#0#0#7'TDBGri'
  +'d'#6'DBGrid'#6'Height'#3#160#0#3'Top'#2'1'#5'Width'#3#235#2#5'Align'#7#5'al'
  +'Top'#10'DataSource'#7#6'dsData'#10'FixedColor'#7#9'clBtnFace'#13'FixedHotCo'
  +'lor'#7#9'cl3DLight'#7'Options'#11#9'dgEditing'#8'dgTitles'#11'dgIndicator'
  +#14'dgColumnResize'#12'dgColumnMove'#10'dgColLines'#10'dgRowLines'#6'dgTabs'
  +#21'dgAlwaysShowSelection'#15'dgConfirmDelete'#14'dgCancelOnExit'#0#12'Optio'
  +'nsExtra'#11#14'dgeAutoColumns'#17'dgeCheckboxColumn'#0#11'ParentColor'#8#8
  +'TabOrder'#2#0#7'TabStop'#9#16'TitleFont.Height'#2#245#14'TitleFont.Name'#6#6
  +'Tahoma'#0#0#6'TPanel'#7'ToolBar'#6'Height'#2'1'#5'Width'#3#235#2#5'Align'#7
  +#5'alTop'#10'BevelOuter'#7#6'bvNone'#12'ClientHeight'#2'1'#11'ClientWidth'#3
  +#235#2#8'TabOrder'#2#1#0#6'TPanel'#6'Panel2'#4'Left'#2#1#6'Height'#2'/'#3'To'
  +'p'#2#1#5'Width'#3#168#1#10'BevelOuter'#7#6'bvNone'#12'ClientHeight'#2'/'#11
  +'ClientWidth'#3#168#1#5'Color'#3#170#0#11'ParentColor'#8#8'TabOrder'#2#0#0#12
  +'TSpeedButton'#7'btClose'#4'Left'#2'\'#6'Height'#2#22#3'Top'#2#1#5'Width'#2
  +'Z'#7'Caption'#6#5'Close'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0
  +#11'Transparent'#8#7'OnClick'#7#12'btCloseClick'#0#0#12'TSpeedButton'#6'btOp'
  +'en'#4'Left'#2#1#6'Height'#2#22#3'Top'#2#1#5'Width'#2'Z'#7'Caption'#6#4'Open'
  +#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'#8#7'OnCl'
  +'ick'#7#11'btOpenClick'#0#0#12'TSpeedButton'#13'btCopyRecord2'#4'Left'#3#183
  +#0#6'Height'#2#22#3'Top'#2#24#5'Width'#2'Z'#7'Caption'#6#15'CopyRecord More'
  +#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'#8#7'OnCl'
  +'ick'#7#18'btCopyRecord2Click'#0#0#12'TSpeedButton'#13'btCopyRecord1'#4'Left'
  +#2'\'#6'Height'#2#22#3'Top'#2#24#5'Width'#2'Z'#7'Caption'#6#14'CopyRecord Al'
  +'t'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'#8#7'O'
  +'nClick'#7#18'btCopyRecord1Click'#0#0#12'TSpeedButton'#12'btCopyRecord'#4'Le'
  +'ft'#2#1#6'Height'#2#22#3'Top'#2#24#5'Width'#2'Z'#7'Caption'#6#10'CopyRecord'
  +#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'#8#7'OnCl'
  +'ick'#7#17'btCopyRecordClick'#0#0#12'TDBNavigator'#11'DBNavigator'#4'Left'#3
  +#183#0#6'Height'#2#22#3'Top'#2#1#5'Width'#3#240#0#10'BevelOuter'#7#6'bvNone'
  +#12'ClientHeight'#2#22#11'ClientWidth'#3#240#0#5'Color'#7#9'clBtnFace'#10'Da'
  +'taSource'#7#6'dsData'#4'Flat'#9#11'ParentColor'#8#8'TabOrder'#2#0#0#0#6'TPa'
  +'nel'#6'Panel6'#4'Left'#3#18#1#6'Height'#2#22#3'Top'#2#24#5'Width'#3#149#0#10
  +'BevelOuter'#7#6'bvNone'#11'ParentColor'#8#8'TabOrder'#2#1#0#0#0#0#7'TDBMemo'
  +#10'meComments'#6'Height'#2'h'#3'Top'#3#237#0#5'Width'#3#235#2#5'Align'#7#8
  +'alClient'#9'DataField'#6#5'VALUE'#10'DataSource'#7#6'dsData'#13'Lines.Strin'
  +'gs'#1#6#10'meComments'#0#10'ScrollBars'#7#10'ssVertical'#8'TabOrder'#2#2#0#0
  +#6'TPanel'#8'ToolBar1'#6'Height'#2#26#3'Top'#3#211#0#5'Width'#3#235#2#5'Alig'
  +'n'#7#5'alTop'#10'BevelOuter'#7#6'bvNone'#12'ClientHeight'#2#26#11'ClientWid'
  +'th'#3#235#2#8'TabOrder'#2#3#0#6'TPanel'#6'Panel1'#4'Left'#2#1#6'Height'#2#24
  +#3'Top'#2#1#5'Width'#3#154#2#10'BevelOuter'#7#6'bvNone'#12'ClientHeight'#2#24
  +#11'ClientWidth'#3#154#2#5'Color'#3#170#0#11'ParentColor'#8#8'TabOrder'#2#0#0
  +#12'TSpeedButton'#7'btClear'#4'Left'#3#183#0#6'Height'#2#22#3'Top'#2#1#5'Wid'
  +'th'#2'Z'#7'Caption'#6#5'Clear'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyph'
  +'s'#2#0#11'Transparent'#8#7'OnClick'#7#12'btClearClick'#0#0#12'TSpeedButton'
  +#6'btSave'#4'Left'#2'\'#6'Height'#2#22#3'Top'#2#1#5'Width'#2'Z'#7'Caption'#6
  +#12'Save to file'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Tran'
  +'sparent'#8#7'OnClick'#7#11'btSaveClick'#0#0#12'TSpeedButton'#6'btLoad'#4'Le'
  +'ft'#2#1#6'Height'#2#22#3'Top'#2#1#5'Width'#2'Z'#7'Caption'#6#14'Load from f'
  +'ile'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'#8#7
  +'OnClick'#7#12'btLoad1Click'#0#0#6'TPanel'#6'Panel3'#4'Left'#3#18#1#6'Height'
  +#2#22#3'Top'#2#1#5'Width'#3#143#0#10'BevelOuter'#7#6'bvNone'#12'ClientHeight'
  +#2#22#11'ClientWidth'#3#143#0#11'ParentColor'#8#8'TabOrder'#2#0#0#9'TCheckBo'
  +'x'#12'cbDefLobRead'#4'Left'#2#15#6'Height'#2#19#5'Width'#2'x'#7'Caption'#6
  +#17'Deferred LOB Read'#7'OnClick'#7#17'cbDefLobReadClick'#8'TabOrder'#2#0#0#0
  +#0#6'TPanel'#6'Panel4'#4'Left'#3#162#1#6'Height'#2#22#3'Top'#2#1#5'Width'#2
  +'_'#10'BevelOuter'#7#6'bvNone'#12'ClientHeight'#2#22#11'ClientWidth'#2'_'#11
  +'ParentColor'#8#8'TabOrder'#2#1#0#9'TCheckBox'#11'cbCacheLobs'#4'Left'#2#8#6
  +'Height'#2#19#5'Width'#2'S'#7'Caption'#6#10'Cache Lobs'#7'OnClick'#7#16'cbCa'
  +'cheLobsClick'#8'TabOrder'#2#0#0#0#0#6'TPanel'#6'Panel5'#4'Left'#3#2#2#6'Hei'
  +'ght'#2#22#3'Top'#2#1#5'Width'#3#151#0#10'BevelOuter'#7#6'bvNone'#12'ClientH'
  +'eight'#2#22#11'ClientWidth'#3#151#0#11'ParentColor'#8#8'TabOrder'#2#2#0#9'T'
  +'CheckBox'#20'cbTemporaryLobUpdate'#4'Left'#2#10#6'Height'#2#19#5'Width'#3
  ,#135#0#7'Caption'#6#20'Temporary Lob Update'#7'OnClick'#7#25'cbTemporaryLobU'
  +'pdateClick'#8'TabOrder'#2#0#0#0#0#0#0#11'TDatasource'#6'dsData'#7'DataSet'#7
  +#5'Query'#4'left'#3#184#1#3'top'#2'8'#0#0#9'TOraQuery'#14'quInsertRecord'#11
  +'SQL.Strings'#1#6'(INSERT INTO ODAC_CLOB (Code,Title,Value)'#6'&  VALUES (:C'
  +'ode, :Title, EMPTY_CLOB())'#6#9'RETURNING'#6#7'  Value'#6#4'INTO'#6#8'  :Va'
  +'lue'#0#5'Debug'#9#17'Options.AutoClose'#8#22'Options.FieldsAsString'#8#23'O'
  +'ptions.DeferredLobRead'#8#24'Options.ScrollableCursor'#8#20'Options.FieldsO'
  +'rigin'#8#21'Options.DefaultValues'#8#19'Options.NumberRange'#8#21'Options.Q'
  +'ueryRecCount'#8#19'Options.AutoPrepare'#8#20'Options.ReturnParams'#8#19'Opt'
  +'ions.FlatBuffers'#8#19'Options.DetailDelay'#2#0#4'left'#3'X'#1#3'top'#2'X'#9
  +'ParamData'#14#1#8'DataType'#7#9'ftInteger'#4'Name'#6#4'Code'#9'ParamType'#7
  +#7'ptInput'#0#1#8'DataType'#7#8'ftString'#4'Name'#6#5'Title'#9'ParamType'#7#7
  +'ptInput'#0#1#8'DataType'#7#9'ftOraClob'#4'Name'#6#5'Value'#9'ParamType'#7#7
  +'ptInput'#0#0#0#0#9'TOraQuery'#12'quCopyRecord'#11'SQL.Strings'#1#6#7'declar'
  +'e'#6#14'  Code NUMBER;'#6#21'  Title VARCHAR2(30);'#6#13'  Value CLOB;'#6#5
  +'begin'#6#25'  SELECT Code,Title,Value'#6#23'  INTO Code,Title,Value'#6#16' '
  +' FROM ODAC_CLOB'#6#23'  WHERE RowId = :RowId;'#6#0#6'*  INSERT INTO ODAC_CL'
  +'OB (Code,Title,Value)'#6'     VALUES (Code, Title, Value);'#6#4'end;'#6#2' '
  +' '#0#5'Debug'#9#17'Options.AutoClose'#8#22'Options.FieldsAsString'#8#23'Opt'
  +'ions.DeferredLobRead'#8#24'Options.ScrollableCursor'#8#20'Options.FieldsOri'
  +'gin'#8#21'Options.DefaultValues'#8#19'Options.NumberRange'#8#21'Options.Que'
  +'ryRecCount'#8#19'Options.AutoPrepare'#8#20'Options.ReturnParams'#8#19'Optio'
  +'ns.FlatBuffers'#8#19'Options.DetailDelay'#2#0#4'left'#3'8'#1#3'top'#2'x'#9
  +'ParamData'#14#1#8'DataType'#7#8'ftString'#4'Name'#6#5'RowId'#4'Size'#3#207#7
  +#0#0#0#0#9'TOraQuery'#14'quSelectRecord'#11'SQL.Strings'#1#6#5'begin'#6#25' '
  +' SELECT Code,Title,Value'#6#26'  INTO :Code,:Title,:Value'#6#16'  FROM ODAC'
  +'_CLOB'#6#23'  WHERE RowId = :RowId;'#6#4'end;'#6#2'  '#0#5'Debug'#9#17'Opti'
  +'ons.AutoClose'#8#22'Options.FieldsAsString'#8#23'Options.DeferredLobRead'#8
  +#24'Options.ScrollableCursor'#8#20'Options.FieldsOrigin'#8#21'Options.Defaul'
  +'tValues'#8#19'Options.NumberRange'#8#21'Options.QueryRecCount'#8#19'Options'
  +'.AutoPrepare'#8#20'Options.ReturnParams'#8#19'Options.FlatBuffers'#8#19'Opt'
  +'ions.DetailDelay'#2#0#4'left'#3'8'#1#3'top'#2'X'#9'ParamData'#14#1#8'DataTy'
  +'pe'#7#9'ftInteger'#4'Name'#6#4'Code'#9'ParamType'#7#8'ptOutput'#0#1#8'DataT'
  +'ype'#7#8'ftString'#4'Name'#6#5'Title'#9'ParamType'#7#8'ptOutput'#4'Size'#3
  +#207#7#0#1#8'DataType'#7#9'ftOraClob'#4'Name'#6#5'Value'#9'ParamType'#7#8'pt'
  +'Output'#0#1#4'Name'#6#5'RowId'#0#0#0#0#9'TOraQuery'#5'Query'#11'SQL.Strings'
  +#1#6'"SELECT C.*, RowId FROM ODAC_CLOB C'#0#5'Debug'#9#17'Options.AutoClose'
  +#8#22'Options.FieldsAsString'#8#23'Options.DeferredLobRead'#8#24'Options.Scr'
  +'ollableCursor'#8#20'Options.FieldsOrigin'#8#21'Options.DefaultValues'#8#19
  +'Options.NumberRange'#8#21'Options.QueryRecCount'#8#19'Options.AutoPrepare'#8
  +#20'Options.ReturnParams'#8#19'Options.FlatBuffers'#8#19'Options.DetailDelay'
  +#2#0#4'left'#3#152#1#3'top'#2'8'#0#0#11'TOpenDialog'#10'OpenDialog'#5'Title'
  +#6#4'Open'#10'InitialDir'#6#1'.'#4'left'#3#240#0#3'top'#3#3#1#0#0#11'TSaveDi'
  +'alog'#10'SaveDialog'#5'Title'#6#7'Save As'#10'InitialDir'#6#1'.'#4'left'#3
  +#16#1#3'top'#3#3#1#0#0#0
]);