>>>>>>>>Hi,
>>>>>>>>
>>>>>>>>Is a way to change the structure of a cursor created with XMLAdapter (to add a column)? For example, the following snippet of code creates this cursor:
>>>>>>>>
>>>>>>>>
>>>>>>>>oXml = CREATEOBJECT("XMLAdapter")
>>>>>>>>oXml.LoadXML( XmlFile, .T. )
>>>>>>>>loTable = oXml.Tables.Item(1)
>>>>>>>>loTable.ToCursor(.F., "MYCURSOR" )
>>>>>>>>
>>>>>>>>
>>>>>>>>And I need to add a column to the cursor MYCURSOR. I tried ALTER TABLE but get error.
>>>>>>>>
>>>>>>>>TIA.
>>>>>>>
>>>>>>>
>>>>>>>Select MYCURSOR.*, cast(0 as Int) as newField into another cursor readwrite ?
>>>>>>
>>>>>>I'm wondering why that field is not in the xml file...
>>>>>
>>>>>The XML is coming from a Pocket PC application and I don't want to change it (if it ain't broke don't fix it type of stuff <g>).
>>>>
>>>>> if it ain't broke
>>>>
>>>>You may want to read this sometime
>>>>
>>>>
http://www.amazon.com/If-Aint-Broke-Break-Unconventional-Changing/dp/0446393592/ref=sr_1_1?ie=UTF8&s=books&qid=1274112273&sr=1-1>>>
>>>Thanks. But I already broke too many things. Plus, the book was published in 1992 <g>.
>>
>>
>>Yes, I got it in Tempe (Phoenix) - was there around that time
>
>Today if you were in Arizona and with your heavy Spanish accent <g> and you got in a drunken fight in a bar<g>, they would deport you back to Mexico <g>
With the Mexican flag on my belt ... From the likes of what I read here I would be in Mexico so fast that my head would spin
Gregory