Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nested Table into XMLFields after any field
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Titre:
Nested Table into XMLFields after any field
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01102420
Message ID:
01102420
Vues:
65
Hallo!

I have the following problem. I have an XML file (a part of it) looking like this:
		<sendung>
			<plz>76351</plz>
			<land>AU</land>
			<kuinfo>1234568</kuinfo>
			<zubrief>
				<transportweg>Luft</transportweg>
			</zubrief>
			<kuinforead>true</kuinforead>
			<position>
				<höhe>1</höhe>
				<gewicht>3,0</gewicht>
				<länge>220</länge>
				<breite>110</breite>
			</position>
			<position>
				<höhe>1</höhe>
				<gewicht>4,0</gewicht>
				<länge>220</länge>
				<breite>110</breite>
			</position>
		</sendung>
There can be several XML tags "position". "zubrief" appears only once. I had no problem in creating a XSD file to read this into an XMLAdapter. If I pass it to cursors I get three cursors (sendung, zubrief, position).

Now the problem occurs in writing the same back. [What I understood is, that it is necessary to create an extra field for relational purposes which is removed from the XMLAdapter before writing it.] When I create a new XMLAdapter and add all the three tables I get a nesting problem: The XMLTable.Nest function allows only a table index as reference but not a field index of the parent table.

In the above structure after the table "zubrief" there is a tag "kuinforead" and then the table "position" is added. As far as I read through the XMLAdapters,tables,fields methods I could not see a solution for a nesting definition like this - all the tables are inserted after all fields of the parent tag. There is only an order for the tables but not for a mixture of tables and fields. [This is not the only example in my XML file.]

Does anybody has an idea for a solution or are there any extra tools?
Répondre
Fil
Voir

Click here to load this message in the networking platform