Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing structure of cursor XMLAdapter
Message
From
17/05/2010 11:56:35
 
 
To
17/05/2010 11:54:32
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01464882
Message ID:
01464900
Views:
48
>>>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...


I wouldn't know
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform