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.