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,