Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating XML file
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01356390
Message ID:
01356417
Vues:
27
This message has been marked as the solution to the initial question of the thread.
CREATE CURSOR crsGroups (grp_name C(10), email C(50))

INSERT INTO crsGroups VALUES ("GROUP1", "myemail1@company.net")
INSERT INTO crsGroups VALUES ("GROUP1", "myemail1@company.net")
INSERT INTO crsGroups VALUES ("GROUP2", "myemail3@company.net")
INSERT INTO crsGroups VALUES ("GROUP3", "myemail4@company.net")
INSERT INTO crsGroups VALUES ("GROUP3", "myemail1@company.net")

CURSORTOXML(ALIAS(), "lcXml")
*? lcXml
XMLTOCURSOR(lcXml, "crsXml")
BROWSE NOWAIT
>I will check the referenced message. Thank you. But I decided to clarify my questoin as following:
>
>I would like to create an XML file that could be converted to the cursor of the following format:
>
>
>GRP_NAME        EMAIL
>---------------         --------
>GROUP1            myemail1@company.net
>GROUP1            myemail1@company.net
>GROUP2            myemail3@company.net
>GROUP3            myemail4@company.net
>GROUP3            myemail1@company.net
>
>
>Here is a sample XML I created but does not seem to do what I am looking for:
>
>
><MYLIST>
>   <GRP_NAME>
>         <NAME>GROUP1</NAME>
>         <EMAIL>myemail1@company.net</EMAIL>
>        <EMAIL>myemail2@company.net</EMAIL>
>   </GRP_NAME>
>  <GRP_NAME>
>         <NAME>GROUP2</NAME>
>         <EMAIL>myemail3@company.net</EMAIL>
>        <EMAIL>myemail4@company.net</EMAIL>
> </GRP_NAME>
></MYLIST>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform