Create_XML_XSD_Schema function

(Introduced in OpenInsight 4.1.3). Creates an XML Schema definition document (.XSD file) from fields in an OpenInsight table.

retval = Create_XML_XSD_Schema(Tablename, Rpt_Fields, Dos_Path, DosFile)

The Create_XML_XSD_Schema function has the following parameters.

The fully qualified path name of the schema file associated with the XML file passed in DOSFile. No error is returned if the schema file is not successfully created.

Extract_XML_Schema_Name(), Get_XML_Value(), Inet_OI_XML(), XML_Importer()

/*

   After the Create_XML_XSD_Schema() function is called, the Extract_XML_Schema_Name() function is called, the file  C:\orders_schema.xsd will contain the schema definition for the ORDER_NO and ITEM_DESCRIPTIONS_ENTERED fields in the ORDERS table.

*/

 

declare function create_xml_xsd_schema

tablename = 'ORDERS'

rpt_fields = 'ORDER_NO':@vm : 'ITEM_DESCRIPTIONS_ENTERED'

dos_path = ''

dosfile = 'C:\orders.xml'

retval = create_xml_xsd_schema( tablename , rpt_fields , dos_path , dosfile)

Sample XSD FileBelow is the contents of the schema file produced by running the example.

 

<?xml version="1.0" ?>

<rti:schema xmlns:rti="http://www.revelation.com/XMLSchema" rti:noNamespaceSchemaLocation="C:\orders.xml_schema.xsd">

<rti:annotation>

  <rti:documentation xml:lang="en">ORDERS schema created by the OpenInsight Schema Creator. Copyright 2003. All rights reserved.</rti:documentation>

</rti:annotation>

<rti:element name="ORDERS" type="OIRowType" />

<rti:complexType name="OIRowType">

  <rti:element name="order_no" type="rti:integer" />

  <rti:element name="item_descriptions_entered_mv" type="item_descriptions_entered_mv_Type" />

</rti:complexType>

<rti:complexType name="item_descriptions_entered_mv_Type">

<rti:element name="item_descriptions_entered" type="rti:string" />

</rti:complexType>

</rti:schema>