Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 15th, 2012  |  syntax: None  |  size: 1.89 KB  |  hits: 17  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. TransXChange XML - SQL Import Schema - Choice Non Deterministic?
  2. <xs:sequence>
  3.  <xs:element name="Location" minOccurs="2" maxOccurs="unbounded" sql:relation="[XXXXX]" sql:relationship="XXXX">
  4.   <xs:complexType>
  5.    <xs:choice>
  6.     <xs:sequence>
  7.      <xs:element name="Longitude" type="xs:decimal" sql:field="Longitude"/>
  8.      <xs:element name="Latitude" type="xs:decimal" sql:field="Latitude"/>
  9.     </xs:sequence>
  10.     <xs:sequence>
  11.      <xs:element name="Translation" sql:is-constant="1">
  12.       <xs:complexType>
  13.        <xs:sequence>
  14.         <xs:sequence>
  15.          <xs:element name="Easting" sql:is-constant="1"/>
  16.          <xs:element name="Northing" sql:is-constant="1"/>
  17.         </xs:sequence>
  18.         <xs:sequence>
  19.          <xs:element name="Longitude" type="xs:decimal" sql:field="Longitude"/>
  20.          <xs:element name="Latitude" type="xs:decimal" sql:field="Latitude"/>
  21.         </xs:sequence>
  22.        </xs:sequence>
  23.       </xs:complexType>
  24.      </xs:element>
  25.     </xs:sequence>
  26.    </xs:choice>
  27.   </xs:complexType>
  28.  </xs:element>
  29. </xs:sequence>
  30.        
  31. <Location>
  32.  <Longitude>-1.371035</Longitude>
  33.  <Latitude>53.504889</Latitude>
  34. </Location>
  35. <Location>
  36.  <Longitude>-1.371006</Longitude>
  37.  <Latitude>53.504879</Latitude>
  38. </Location>
  39. <Location>
  40.  <Longitude>-1.368606</Longitude>
  41.  <Latitude>53.504449</Latitude>
  42. </Location>
  43.        
  44. <Location id="4153">
  45.  <Translation>
  46.   <Easting>443220</Easting>
  47.   <Northing>393309</Northing>
  48.   <Longitude>-1.35091198667809</Longitude>
  49.   <Latitude>53.4347979973958</Latitude>
  50.  </Translation>
  51. </Location>
  52. <Location id="4154">
  53.  <Translation>
  54.   <Easting>443196</Easting>
  55.   <Northing>393323</Northing>
  56.   <Longitude>-1.35127098667824</Longitude>
  57.   <Latitude>53.434925997396</Latitude>
  58.  </Translation>
  59. </Location>
  60. <Location id="4155">
  61.  <Translation>
  62.   <Easting>443196</Easting>
  63.   <Northing>393323</Northing>
  64.   <Longitude>-1.35127098667824</Longitude>
  65.   <Latitude>53.434925997396</Latitude>
  66.  </Translation>
  67. </Location>
create a new version of this paste RAW Paste Data