Hi Sergey
on further looking at this I see my problem. First off I now see my result wasn't empty it had blank lines at the start.
I have several tables I am adding with addtablschema.
That xml is then passed to the taget machine and the tables extracted.
One of the tables has a field called title .
One of the tables is called title.
The extracted title table has as many blank records as there are records in the table with a field called title.
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.
>>