Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Joriveek Joriveek
  Where is Joriveek Joriveek?
 Joriveek Joriveek
 To: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Boudewijn Lutgerink
Subject: RE: dbc to xml
Thread ID: 33769 Message ID: 33786 # Views: 3 # Ratings: 0
Version: Visual FoxPro 7 Category: XML
Date: Wednesday, December 03, 2003 4:52:20 PM         

Yes, I want to produce one XML (which includes all the contents and layout of my DBC file)...just like one XML for each table what CURSORTOXML does for us. Because that is the format requested by some one to whom I need to send the data from VFP to their (black box) application. I don't know anything about their spec. All that I need to send all the transactions of all the tables (in my DBC) in XML format and send it to them. I think their application will easily identify the XML formatted data and later they can import into their application.

I have tried

CURSORTOXML("table1", "myxml.xml",1,512, 0,"")
I found the following myxml.xml:



But when I use XMLTOCURSOR("myxml.xml", "table1", 8192)

I get the XML Parse error: Invalid at the top level of the document Line1, Position 1. myxml.xml.

It is the same thing I am trying to produce. I am using the same XML document produced by the FoxPro. Any help where I am going wrong.


> >
> > I want to get one XML from all the tables in my DBC. I think CURSORTOXML does one table at a time to a XML.
> >
> > Any idea how can I convery DBC file to XML?
> >
> > Thanks
> > J.
> what do you want, just the table layout or the content of all the tables. In case of the latter... are you sure you want that?
> Boudewijn LutgeĀ®ink
> Boudewijn.Lutgerink@foxite.com
> The music, played at a wedding, reminds me every time to music played when soldiers march to the frontier... (Heinrich Heine)


dbc to xml Posted by Joriveek Joriveek @ 12/3/2003 12:05:36 PM
RE: dbc to xml Posted by Boudewijn Lutgerink @ 12/3/2003 1:28:45 PM
RE: dbc to xml Posted by Joriveek Joriveek @ 12/3/2003 4:52:20 PM
RE: dbc to xml Posted by Ken Blum @ 12/4/2003 8:21:18 PM
RE: dbc to xml Posted by Boudewijn Lutgerink @ 12/5/2003 11:35:14 AM
RE: dbc to xml Posted by Ken Blum @ 12/5/2003 5:03:07 PM
RE: dbc to xml Posted by Jamie Osborn @ 12/5/2003 9:43:37 PM