Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursors are empty when loading XML file
Message
De
17/01/2005 19:41:36
 
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
00976969
Message ID:
00977922
Vues:
23
Here is some rough schema that get you started. Tables.count will return 4 but there are are only 3 with fields so tables(xx).tocursor will only create 3 tables. You will need to edit the xs:string to change to the datatypes/lengths you want.
<?xml version='1.0' encoding='UTF-8'?><vsdataset xmlns="http://tempuri.org/ut.xsd">
  <xs:schema id="vsdataset" targetNamespace="http://tempuri.org/ut.xsd" xmlns:mstns="http://tempuri.org/ut.xsd" xmlns="http://tempuri.org/ut.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
    <xs:element name="vsdataset" msdata:IsDataSet="true">
      <xs:complexType>
        <xs:choice maxOccurs="unbounded">
          <xs:element name="LCS_VirtualConsultation">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="Patient" minOccurs="0" maxOccurs="unbounded">
                  <xs:complexType>
                    <xs:sequence>
                      <xs:element name="NHINumber" type="xs:string" minOccurs="0" />
                      <xs:element name="PatientFullName" type="xs:string" minOccurs="0" />
                      <xs:element name="DateOfBirth" type="xs:string" minOccurs="0" />
                      <xs:element name="Gender" type="xs:string" minOccurs="0" />
                      <xs:element name="AddressLine1" type="xs:string" minOccurs="0" />
                      <xs:element name="AddressLine2" type="xs:string" minOccurs="0" />
                      <xs:element name="Suburb" type="xs:string" minOccurs="0" />
                      <xs:element name="City" type="xs:string" minOccurs="0" />
                      <xs:element name="TelHome" type="xs:string" minOccurs="0" />
                      <xs:element name="TelWork" type="xs:string" minOccurs="0" />
                      <xs:element name="TelMobile" type="xs:string" minOccurs="0" />
                      <xs:element name="ConsultationNotes" type="xs:string" minOccurs="0" />
                      <xs:element name="MedicalInformation" minOccurs="0" maxOccurs="unbounded">
                        <xs:complexType>
                          <xs:sequence>
                            <xs:element name="DiabetesType" type="xs:string" minOccurs="0" />
                            <xs:element name="LipidDisorder" type="xs:string" minOccurs="0" />
                            <xs:element name="HbA1c" type="xs:string" minOccurs="0" />
                            <xs:element name="CholesterolHDL" type="xs:string" minOccurs="0" />
                            <xs:element name="CholesterolLDL" type="xs:string" minOccurs="0" />
                            <xs:element name="Hypertension" type="xs:string" minOccurs="0" />
                            <xs:element name="DateDiabetesDiagnosed" type="xs:string" minOccurs="0" />
                          </xs:sequence>
                        </xs:complexType>
                      </xs:element>
                      <xs:element name="DiagnosticInformation" minOccurs="0" maxOccurs="unbounded">
                        <xs:complexType>
                          <xs:sequence>
                            <xs:element name="RetinopathyRight" type="xs:string" minOccurs="0" />
                            <xs:element name="RetinopathyLeft" type="xs:string" minOccurs="0" />
                            <xs:element name="MaculopathyRight" type="xs:string" minOccurs="0" />
                            <xs:element name="MaculopathyLeft" type="xs:string" minOccurs="0" />
                          </xs:sequence>
                        </xs:complexType>
                      </xs:element>
                    </xs:sequence>
                  </xs:complexType>
                </xs:element>
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform