Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible ER for XMLToCursor
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00690093
Message ID:
00691292
Views:
22
Evan,

>With VFP7SP1, we can use XMLTOCURSOR to append a record to an existing table. What do people think about enhancing this to allow an existing record to be overwritten? For example:

Hank already pointed you to XMLUpdateGram().

What I would really appreciate in VFP8 would be a possibility so submit an Updategram to a cursor.

I'm currently writing a "quick and dirty" (more dirty than quick < g >) parser that makes the changes documented in an Updategram in a cursor. It's a real pain. In the beginning it looks like an easy job, but you have to take special care of NULL values (element may exist in the updg:before section, but not in the updg:after section - that means it had a value before the change was made, and was set to .NULL.), etc.

So having something like XMLUpdateGramToCursor(lcXMLUpdg, ALIAS()) would IMO be a great enhancement.

I had a look into the wishlist, it's already in there. But I added it to another XMLUpdateGram wish of mine, to emphasise the importance < g >.

Regards,
Armin

Armin Neudert
Regional Director (Stuttgart) of German FoxPro User Group dFPUG

MCP for Visual FoxPro

Expert/Editor of the VFP section in the German Codezone community portal
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform