Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing structure of cursor XMLAdapter
Message
De
17/05/2010 11:56:35
 
 
À
17/05/2010 11:54:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01464882
Message ID:
01464900
Vues:
47
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform