To create the entire XML file at once.

If you have VFP7, the CURSORTOXML() function creates an XML table from a cursor.
If you have VFP6 you can use the free wwXML from West Wind at
http://www.west-wind.com/Webtools.asp


>Requirement - Creating an output file in XML format for every record in a table.
>
>Logic - Create an XML object and keep adding child nodes for each record in the table to the XML document object. Once I finish adding all records to the XML document object. I will use the XMLdocument save method to create the XML document.
>
>Question - Is there a limitation on how many nodes I can keep adding? There are can be millions of records in a given table on a given day. Is this the best way to do it? Is there any other way to do this?