tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,924
- Office Version
- 365
- 2019
- Platform
- Windows
According to this page:
if I want to create a schema consisting of four attributes, LastName, Sales, Country and Quarter, I can do it like this:
According to this webpage,
if I want to add restrictions, it can be done like so:
so if I want to create a schema with four attributes, LastName, Sales, Country and Quarter with restrictions, how would that be done?
Thanks
Code:
https://www.excel-easy.com/examples/xml.html
if I want to create a schema consisting of four attributes, LastName, Sales, Country and Quarter, I can do it like this:
Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<data-set xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<record>
<LastName>Smith</LastName>
<Sales>16753</Sales>
<Country>UK</Country>
<Quarter>Qtr 3</Quarter>
</record>
<record>
<LastName>Johnson</LastName>
<Sales>14808</Sales>
<Country>USA</Country>
<Quarter>Qtr 4</Quarter>
</record>
</data-set>
According to this webpage,
Code:
https://www.w3schools.com/xml/schema_facets.asp
if I want to add restrictions, it can be done like so:
Code:
<xs:element name="age">
<xs:simpleType>
<xs:restriction base="xs:integer">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="120"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
so if I want to create a schema with four attributes, LastName, Sales, Country and Quarter with restrictions, how would that be done?
Thanks