xmltype.lrs

Oracle Data Access Components Source Code ODAC v.6.70.0.45

LazarusResources.Add('TXMLTypeFrame','FORMDATA',[
  'TPF0'#13'TXMLTypeFrame'#12'XMLTypeFrame'#6'Height'#3#31#1#5'Width'#3#136#2#0
  +#6'TPanel'#8'ToolBar1'#6'Height'#2'0'#5'Width'#3#136#2#5'Align'#7#5'alTop'#10
  +'BevelOuter'#7#6'bvNone'#12'ClientHeight'#2'0'#11'ClientWidth'#3#136#2#8'Tab'
  +'Order'#2#0#0#6'TPanel'#6'Panel1'#6'Height'#2#24#5'Width'#3'0'#2#10'BevelOut'
  +'er'#7#6'bvNone'#12'ClientHeight'#2#24#11'ClientWidth'#3'0'#2#5'Color'#3#170
  +#0#11'ParentColor'#8#8'TabOrder'#2#0#0#12'TSpeedButton'#6'btOpen'#4'Left'#2#1
  +#6'Height'#2#22#3'Top'#2#1#5'Width'#2'R'#7'Caption'#6#4'Open'#5'Color'#7#9'c'
  +'lBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'#8#7'OnClick'#7#11'btOp'
  +'enClick'#0#0#12'TSpeedButton'#7'btClose'#4'Left'#2'T'#6'Height'#2#22#3'Top'
  +#2#1#5'Width'#2'R'#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'TSpee'
  +'dButton'#8'btCreate'#4'Left'#3#132#1#6'Height'#2#22#4'Hint'#6#18'Create XML'
  +' objects'#3'Top'#2#1#5'Width'#2'U'#7'Caption'#6#6'Create'#5'Color'#7#9'clBt'
  +'nFace'#4'Flat'#9#11'Font.Height'#2#245#9'Font.Name'#6#6'Tahoma'#10'Font.Sty'
  +'le'#11#6'fsBold'#0#9'NumGlyphs'#2#0#11'Transparent'#8#7'OnClick'#7#13'btCre'
  +'ateClick'#0#0#12'TSpeedButton'#6'btDrop'#4'Left'#3#218#1#6'Height'#2#22#4'H'
  +'int'#6#16'Drop XML objects'#3'Top'#2#1#5'Width'#2'U'#7'Caption'#6#4'Drop'#5
  +'Color'#7#9'clBtnFace'#4'Flat'#9#11'Font.Height'#2#245#9'Font.Name'#6#6'Taho'
  +'ma'#10'Font.Style'#11#6'fsBold'#0#9'NumGlyphs'#2#0#11'Transparent'#8#7'OnCl'
  +'ick'#7#11'btDropClick'#0#0#12'TDBNavigator'#12'DBNavigator1'#4'Left'#3#167#0
  +#6'Height'#2#22#3'Top'#2#1#5'Width'#3#220#0#10'BevelOuter'#7#6'bvNone'#12'Cl'
  +'ientHeight'#2#22#11'ClientWidth'#3#220#0#5'Color'#7#9'clBtnFace'#10'DataSou'
  +'rce'#7#6'dsData'#4'Flat'#9#11'ParentColor'#8#8'TabOrder'#2#0#0#0#0#6'TPanel'
  +#6'Panel3'#6'Height'#2#23#3'Top'#2#24#5'Width'#3#4#2#10'BevelOuter'#7#6'bvNo'
  +'ne'#12'ClientHeight'#2#23#11'ClientWidth'#3#4#2#5'Color'#3#170#0#11'ParentC'
  +'olor'#8#8'TabOrder'#2#1#0#12'TSpeedButton'#12'SpeedButton2'#4'Left'#3#250#0
  +#6'Height'#2#22#5'Width'#2'R'#7'Caption'#6#9'Transform'#5'Color'#7#9'clBtnFa'
  +'ce'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'#8#7'OnClick'#7#17'SpeedButto'
  +'n2Click'#0#0#12'TSpeedButton'#11'btAddRecord'#4'Left'#2#1#6'Height'#2#22#5
  +'Width'#2'R'#7'Caption'#6#10'Add Record'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9
  +'NumGlyphs'#2#0#11'Transparent'#8#7'OnClick'#7#16'btAddRecordClick'#0#0#12'T'
  +'SpeedButton'#13'btShowCountry'#4'Left'#2'T'#6'Height'#2#22#5'Width'#2'R'#7
  +'Caption'#6#9'GetSchema'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0
  +#11'Transparent'#8#7'OnClick'#7#18'btShowCountryClick'#0#0#12'TSpeedButton'
  +#12'SpeedButton1'#4'Left'#3#167#0#6'Height'#2#22#5'Width'#2'R'#7'Caption'#6#7
  +'Extract'#5'Color'#7#9'clBtnFace'#4'Flat'#9#9'NumGlyphs'#2#0#11'Transparent'
  +#8#7'OnClick'#7#17'SpeedButton1Click'#0#0#6'TPanel'#6'Panel2'#4'Left'#3'M'#1
  +#6'Height'#2#22#5'Width'#3#182#0#10'BevelOuter'#7#6'bvNone'#12'ClientHeight'
  +#2#22#11'ClientWidth'#3#182#0#11'ParentColor'#8#8'TabOrder'#2#0#0#6'TLabel'#6
  +'Label1'#4'Left'#2#15#6'Height'#2#14#3'Top'#2#4#5'Width'#2'1'#7'Caption'#6#9
  +'Based on:'#11'ParentColor'#8#0#0#12'TRadioButton'#12'RadioButton1'#4'Left'#2
  +'B'#6'Height'#2#19#3'Top'#2#3#5'Width'#2'A'#7'Caption'#6#6'Schema'#7'OnClick'
  +#7#17'RadioButton1Click'#8'TabOrder'#2#0#0#0#12'TRadioButton'#12'RadioButton'
  +'2'#4'Left'#3#128#0#6'Height'#2#19#3'Top'#2#3#5'Width'#2','#7'Caption'#6#3'L'
  +'ob'#7'Checked'#9#7'OnClick'#7#17'RadioButton1Click'#5'State'#7#9'cbChecked'
  +#8'TabOrder'#2#1#0#0#0#0#0#7'TDBGrid'#6'DBGrid'#6'Height'#3#169#0#3'Top'#2'0'
  +#5'Width'#3#136#2#5'Align'#7#8'alClient'#10'DataSource'#7#6'dsData'#10'Fixed'
  +'Color'#7#9'clBtnFace'#13'FixedHotColor'#7#9'cl3DLight'#7'Options'#11#9'dgEd'
  +'iting'#8'dgTitles'#11'dgIndicator'#14'dgColumnResize'#12'dgColumnMove'#10'd'
  +'gColLines'#10'dgRowLines'#6'dgTabs'#21'dgAlwaysShowSelection'#15'dgConfirmD'
  +'elete'#14'dgCancelOnExit'#0#12'OptionsExtra'#11#14'dgeAutoColumns'#17'dgeCh'
  +'eckboxColumn'#0#11'ParentColor'#8#8'TabOrder'#2#1#7'TabStop'#9#16'TitleFont'
  +'.Height'#2#245#14'TitleFont.Name'#6#6'Tahoma'#0#0#7'TDBMemo'#7'DBMemo1'#6'H'
  +'eight'#2'F'#3'Top'#3#217#0#5'Width'#3#136#2#5'Align'#7#8'alBottom'#9'DataFi'
  +'eld'#6#8'XMLField'#10'DataSource'#7#6'dsData'#13'Lines.Strings'#1#6#7'DBMem'
  +'o1'#0#8'TabOrder'#2#2#0#0#11'TDatasource'#6'dsData'#7'DataSet'#7#5'Query'#4
  +'left'#2#24#3'top'#2'P'#0#0#11'TSmartQuery'#5'Query'#11'SQL.Strings'#1#6#0#0
  +#5'Debug'#9#9'FetchRows'#2#20#8'LockMode'#7#6'lmNone'#14'RefreshOptions'#11
  +#13'roAfterInsert'#13'roAfterUpdate'#0#17'Options.AutoClose'#8#22'Options.Fi'
  +'eldsAsString'#8#23'Options.DeferredLobRead'#8#24'Options.ScrollableCursor'#8
  +#20'Options.FieldsOrigin'#8#21'Options.DefaultValues'#8#19'Options.NumberRan'
  +'ge'#8#21'Options.QueryRecCount'#8#19'Options.AutoPrepare'#8#20'Options.Retu'
  +'rnParams'#8#19'Options.FlatBuffers'#8#19'Options.DetailDelay'#2#0#4'left'#3
  +#168#0#3'top'#2'h'#0#0#7'TOraSQL'#6'OraSQL'#5'Debug'#9#4'left'#3#200#0#3'top'
  ,#2'h'#0#0#10'TOraScript'#8'scCreate'#11'SQL.Strings'#1#6#7'declare'#6#21'doc'
  +' varchar2(2000) :='#6'7''<schema targetNamespace="http://www.oracle.com/PO.'
  +'xsd"'#6')  xmlns:po="http://www.oracle.com/PO.xsd"'#6'+  xmlns="http://www.'
  +'w3.org/2001/XMLSchema">'#6'(  <complexType name="PurchaseOrderType">'#6#14
  +'    <sequence>'#6',      <element name="PONum" type="decimal"/>'#6#0#6#30' '
  +'     <element name="Company">'#6#20'        <simpleType>'#6'%          <res'
  +'triction base="string">'#6'$            <maxLength value="100"/>'#6#24'    '
  +'      </restriction>'#6#21'        </simpleType>'#6#16'      </element>'#6#0
  +#6',      <element name="Item" maxOccurs="1000">'#6#21'        <complexType>'
  +#6#20'          <sequence>'#6'!            <element name="Part">'#6#26'     '
  +'         <simpleType>'#6'+                <restriction base="string">'#6'+ '
  +'                 <maxLength value="1000"/>'#6#30'                </restrict'
  +'ion>'#6#27'              </simpleType>'#6#22'            </element>'#6#0#6
  +'0            <element name="Price" type="float"/>'#6#0#6#21'          </seq'
  +'uence>'#6#22'        </complexType>'#6#16'      </element>'#6#0#6#15'    </'
  +'sequence>'#6#16'  </complexType>'#6'=  <element name="PurchaseOrder" type="'
  +'po:PurchaseOrderType"/>'#6#11'</schema>'';'#6#5'begin'#6'E  dbms_xmlschema.'
  +'registerSchema(''http://www.oracle.com/PO.xsd'', doc);'#6#4'end;'#6#1'/'#6#0
  +#6#29'CREATE TABLE xmlschema_type ('#6#24'  ID NUMBER PRIMARY KEY,'#6#22'  X'
  +'MLField SYS.XMLType'#6#1')'#6#23'XMLTYPE COLUMN XMLField'#6'*  XMLSCHEMA "h'
  +'ttp://www.oracle.com/PO.xsd"'#6#26'  ELEMENT "PurchaseOrder";'#6#0#6#23'CRE'
  +'ATE TABLE xml_type ('#6#24'  ID NUMBER PRIMARY KEY,'#6#18'  XMLField XMLTYP'
  +'E'#6#2');'#6#0#6'"INSERT INTO xmlschema_type VALUES('#6#4'  1,'#6#26'  XMLT'
  +'YPE(''<PurchaseOrder '#6#170'xmlns="http://www.oracle.com/PO.xsd" xmlns:xsi'
  +'="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www'
  +'.oracle.com/PO.xsd http://www.oracle.com/PO.xsd">'#6#19'  <PONum>73</PONum>'
  +#6'   <Company>Oracle Corp</Company>'#6#8'  <Item>'#6#27'    <Part>9i Doc Se'
  +'t</Part>'#6#22'    <Price>130</Price>'#6#9'  </Item>'#6#8'  <Item>'#6#27'  '
  +'  <Part>8i Doc Set</Part>'#6#22'    <Price>946</Price>'#6#9'  </Item>'#6#17
  +'</PurchaseOrder>'''#6#3'  )'#6#2');'#6#0#6#28'INSERT INTO xml_type VALUES('
  +#6#4'  1,'#6#26'  XMLTYPE(''<PurchaseOrder>'#6#19'  <PONum>73</PONum>'#6'   '
  +'<Company>Oracle Corp</Company>'#6#8'  <Item>'#6#27'    <Part>9i Doc Set</Pa'
  +'rt>'#6#22'    <Price>130</Price>'#6#9'  </Item>'#6#8'  <Item>'#6#27'    <Pa'
  +'rt>8i Doc Set</Part>'#6#22'    <Price>946</Price>'#6#9'  </Item>'#6#17'</Pu'
  +'rchaseOrder>'''#6#3'  )'#6#2');'#6#0#6#28'INSERT INTO xml_type VALUES('#6#4
  +'  2,'#6#10'  XMLTYPE('#6#24'    ''<root>value</root>'''#6#3'  )'#6#2');'#6#0
  +#6#7'COMMIT;'#0#4'left'#3#224#0#3'top'#2'8'#0#0#10'TOraScript'#6'scDrop'#11
  +'SQL.Strings'#1#6#20'DROP TABLE xml_type;'#6#0#6#26'DROP TABLE xmlschema_typ'
  +'e;'#0#4'left'#3#0#1#3'top'#2'8'#0#0#0
]);