>Hi,
>
>I need to create an XML Table from a Windows Form using an SQL table as the source.
>
>Know very little about XML.
>
>SELECT ClientNum, LastName, FirstName, SignificantOther, Address, City, State, ZipCode, AddressAfterClose, CityAfterClose, StateAfterClose, ZipAfterClose, HomePhone, WorkPhone, WorkPhoneExt, CellPhone, FaxNumber, EmailAddress, Comments, InsertDateTime FROM dbo.Client WHERE (LastName LIKE ?)
>
>How would I create the XML table with the result rows?
>
>Thanks
>Roland
I tried to hold back but... In VFP7
cursortoxml(lcName, lcRowName, lnIndent, llNoHeader) and its done.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams