Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xml contents
Message
De
03/05/2006 04:58:48
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Titre:
Divers
Thread ID:
01117446
Message ID:
01118702
Vues:
12
Hi Sergey thanks for that.

Having just cut out the relevant lines of code to reply to you I tried running them on their own and the damn thing worked so there must be something else causing my problem ( . I'll have to dig some more.

Thanks again.

Nick

>Nick,
>
>The following works for me
>CLOSE DATABASES
>
>CREATE CURSOR title (titleid i, name C(30))
>INSERT INTO title VALUES (1, "One")
>INSERT INTO title VALUES (2, "Two")
>INSERT INTO title VALUES (3, "Three")
>lcXml = ""
>? CURSORTOXML(ALIAS(), "lcXml", 1, 0, 0, "1")
>oXA = CREATEOBJECT("XmlAdapter")
>oXA.LoadXML(lcXml)
>oT = oXA.Tables.Item(1)
>oT.ToCursor(, "crsTitle")
>
>BROWSE LAST NOWAIT
>
How is it different from what you're doing?
>
>>
>>I have a table called title with fields titleid and name.
>>
>>I'm passing this data via xml along with other tables.
>>
>>loading it in with addtableschema then getting it back out with tocursor.
>>
>>This works in a loop and I get all my data for the other tables in the xml but I get nothing for the table title. I get the field names in a cursor but no data. I'm guessing title is some sort of reserved word causing this problem. Anyone know ? Plus is there any sort of workaround before I make one up.
>>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform