Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting hierarchical xml to vfp
Message
From
16/08/2002 09:57:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Converting hierarchical xml to vfp
Miscellaneous
Thread ID:
00690345
Message ID:
00690345
Views:
71
I have invoices in a hierarchical xml format:
<?xml version="1.0" encoding="ISO-8859-1"?>
<invoice>
    <number>11009</number>
    <date>20020801</date>
    <rows>
        <row>
            <item>80686001508</item>
            <quantity>2</quantity>
        </row>
        <row>
            <item>2136861443</item>
            <quantity>4.5</quantity>
        </row>
    </rows>
</invoice>
I need to create a vfp dbf file from this file.

I tried
XMLTOCURSOR('invoice.xml','invoice',512)
but almost all data is missing from the result cursor.

How to to convert this xml file to a vfp ?
I need a singe dbf file or separate dbf files.
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform