troubleshooting Question

XML and Foxpro

Avatar of fmoore0001
fmoore0001 asked on
FoxPro
4 Comments3 Solutions994 ViewsLast Modified:
I have a client with a need for XML output  from Foxpro.  I have played with it a bit in the past- enough to generate something useful, but he needs a specific header in his XML file and I have not figured out how add it:

In the past I have made simple XML files from a Cursor that generate data in this fashion:
<?xml version="1.0"?>
 -<Tablename>
       -<Field1>datum1</Field1>
       -<Field2>datam2</Field2>
 -</Tablename>

Foxpro will do that just with the CURSORTOXML() command.  But, this time I need to add some sort of a header defination:

<?xml version="1.0"?>
   -<Mcr reportingDate="2011-01-01" periodType="MCRYTD" year="2011" type="S">
        -<Tablename>
            -<Field1>datum1</Field1>
            -<Field2>datam2</Field2>
       -</Tablename>
  -</mcr>

And I am lost how to do this.  Any ideas, or useful references to a how to guide on this?

Frank
ASKER CERTIFIED SOLUTION
Pavel Celba
All in One

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros