Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xml contents
Message
 
 
To
28/04/2006 07:59:51
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Miscellaneous
Thread ID:
01117446
Message ID:
01117826
Views:
13
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.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform