>>>>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
Gregory