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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao