On Tue, Apr 14, 2009 at 1:40 PM, MB Software Solutions General Account <mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > Stephen Russell wrote: >> Why not ask those M$ guys why they didn't offer to help you with this: >> >> I bet you could write a real quick reader of the xml to a dataset and >> then write that dataset's table to a VFP dbf. >> >> Maybe an hour to do it. Maybe a few hours if your doing conversion >> along the way. > > > Hey Steve, > > When you're done with that, post it up on the ProFox downloads page. <g> --------------------------------
Charlie might puke if he saw that so I wouldn't just for him. ;) in all honesty it is a real simple turn and burn Read the file http://quickstart.developerfusion.co.uk/quickstart/howto/doc/Xml/LoadDataSetXMLData.aspx write the output Well the sites I saw had some problems and were asking for answers. So you set your connection, and open it. You iterate through the datatable taking to determine if your datatable schema is = dbf schema . If good you just take each row and make your dynamic sql statement and then run it via an ODBC connection in VFP. Not that hard. -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c4313dbe0904141206j54b7d07dhcd738ccd89d54...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.