Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorToXML support for multiple Cursors into a single X
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00507156
Message ID:
00549809
Views:
23
I don't. We are in the process here of determining if we want to go this way or not. If so, we know we'll probably have to write our own. Rick Strahl may have something on his web site. Erik Moore (who hangs out regularly) wrote one but I don't know if its public domain. He may jump in here with his $0.02.

Good luck.

>I was looking at the structure of the updategram, and thought about how I was going to do a SQL-Update with the information in it. I figured that the best thing would be to get the updategram into a cursor that I could SCAN and then do my SQL-Update on each row. I see I can't cleanly do that...
>
>What kind of VFP code is out there to apply an updategram on VFP data? If there isn't any, then I guess I'd have to make my own VFP function to instance the XMLDOM object and step through each element and do SQL-Update based on what is found, right?
>
>Do you (does anyone?) have any XMLUpdateGram() samples out there I hack like me could check out?
>
>Thanks again.
>
>
>
>>Steve,
>>XMLUpdategram does not give you a representation you can turn into another cursor. It gives you the information you need to create a SQL UPDATE statement to update the back-end data.
>
>>>Have you worked with XMLUpdateGram()? I am trying to use it to pass data between VFP servers, but it looks like the function doesn't make "cursorizable" XML that I can merge into the back-end. Is there more documentation somewhere on this?
>>>
>>>
>>>Clear
>>>Close Tables all
>>>
>>>USE c:\wintemp\zip IN 0 SHARED
>>>Select zip
>>>Set Multilocks on
>>>? CursorSetProp('buffering',5)
>>>? CursorSetProp("KeyFieldList","iid")
>>>
>>>CursorToXML("zip", "c:\wintemp\zip.xml", 1, 512, 0, "zip.xsd")
>>>
>>>Replace all state with "zz" for Recno() <= 15
>>>
>>>cOutGram = XMLUpdategram("zip",2+4+8+32)
>>>StrToFile(cOutGram,"c:\wintemp\zipgram.xml",0)
>>>
>>>
>>>? Chr(13) + Chr(10)
>>>? XMLToCursor("c:\wintemp\zipgram.xml","incursor",4)
>>>
>>>
>>>
>>>
>>>Thx.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform