Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursortoxml()
Message
 
 
À
17/02/2004 19:09:11
Andy Roth
Neyenesch Printers
Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00878147
Message ID:
00878166
Vues:
19
Hi, Andy.

>I have been playing with cursortoxlm().
>Is there a way to break out the one in the one to many
>using this or any other function in foxpro 8.0
>
>Example:
>Data from cursor is 3 rows with a left join
>to 1 record from a header table (customer) and 3 records from
>and item table (invoice1,invoice2 & invoice3).
>
>customer,invoice1
>customer,invoice2
>customer,invoice3
>
>
>Wanted Output
> customer
> invoice1
> invoice2
> invoice3
>
>rather than
> customer
> invoice1
> customer
> invoice2
> customer
> invoice3
>
>I am trying to work with Great Plains eConnect to
>import for exported data into an xml file
>
>Great Plains needs to information grouped by the
>one record and the many listed inside those tags

To do this now you have to resort to manually process your XML (using the MsXml parser). It is planned for Europa (next VFP version) to support that kind of XML hierarchies, although it hasn't being explained -AFAIK- how it owuld be implemented.

See you,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform