ANTHEVA - Sample 2 : How to convert Sql to XML


Description : if you wish to convert the result of your SQL queries into XML files, here is a useful tool. You create your SELECT queries, define the concerned database(s) and get the result in a XML file.

This application was tested with Ms Access
and ORACLE. It works for both....

Hard Copies


Creating a query.
Create a new query, and associate a database. Choose the XML Pattern
("list" : datas are stored in attributes ou "Nodes" : datas are stored in nodes),
then click on the ">>" button to execute the query. Don't forget to click on the button "Save the query".



The same query executed in "list" mode.
This time each item is stored in a line and data is stored in an attribute.



Entering the database connexion parameters.
Enter the driver, then the url and the login/password.


<< Previous sample