Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Form class to edit XML
Message
From
13/09/2006 14:40:11
 
General information
Forum:
Visual FoxPro
Category:
Internet applications
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153373
Message ID:
01153479
Views:
17
>>
>>I have memo field that is populated with XML data with dozens of elements. What I'd like is an easy way to create a form to edit this data and then push it back into the memo field. This data was originally created from an Cursortoxml command so it is possible that I could get a schema generated.
>>
>>Does anyone know of a class or a 'best practices' approach on how to edit XML data without a lot of excessive coding?
>>
>
>
>Hi Greg,
>
>Do you want to edit XML or data stored in the XML? If later, you can cover XML back to cursor with XMLTOCURAOR(), edit it and back to XML.

Thanks for the reply. I want to edit the data that is stored in the XML. So perhaps the easiest way would be to convert the XML using XMLTOCURSOR(), then use the resulting cursor to dynamically build the form, then when the form is saved convert it back to XML with CURSORTOXML(). Or perhaps I could use the schema to decide how to build the form, because it has the data types and lengths, then just use the XMLTOCURSOR to bind the data to the control sources. Do you know if there is anything out there in VFP that will take an XML schema and create a form to edit the associated XML? Hopefully I'm being clear here. Seems like it would be so useful that it's probably been done and I don't want to revent the wheel.

Thanks for all your help.

Greg
Previous
Reply
Map
View

Click here to load this message in the networking platform