Welcome Guest | My Membership | Login

More MultiValue Database and Products Articles...

Tech Tip

Creating XML data quickly and easily with tools you may already have.

 

 

Twitter Button from twitbuttons.com

Release Date: Monday, January 01, 0001

If you are using UniVerse or UniData, did you know you can create XML data using your standard LIST and SELECT statements?

LIST CUST NAME ADDRESS PHONE ID-SUPP TOXML

Will create the following:

<?xml version="1.0"?>
<ROOT>
<CUST>
<NAME_MV NAME = "International Spectrum"/>
<ADDRESS_MV ADDRESS = "80 Garden Center, Suite 6"/>
<PHONE_MV PHONE = "720-259-1356"/>
</CUST>
<CUST>
<NAME_MV NAME = "Nathan Rector"/>
<ADDRESS_MV ADDRESS = "Unknown"/>
<PHONE_MV PHONE = "999-999-9999"/>
</CUST>
</ROOT>

If you sent this to a Spooler Hold File, and then copied it out to .XML windows file, you would be able to open the your data in Excel.

 

# # #          # # #          # # #

 

Related Articles:


Return to top