Russell,
What I do is take the generated Updategram and just pass it as a parameter to the generic class below. Using wwIPStuff, it just gets added as a postkey then gets posted to the XML directory you defined using the MS tool included in the XML Tools download. In the end, it is really no different than sending a page to a webserver. There is nothing 'saved' on the server and it returns an XML results file. Sample code is below.
One more thing...I am not using the Updategram function in VFP 7. I rolled my own, with a lot of help from Erik Moore's XML / XSL table builder, which you can download here on the UT (number 1254). I assume the updategram generated by VFP would work just as well.
If you don't use wwIPStuff, the MS XML Parser includes the capability to post a document (xmlhttp?) to the server. I have used wwIPStuff for a couple of years with no problems. And the price is right.
Rick
***** code *****
Param lcXML
oIP=CREATE("wwIPSTUFF")
oIP.nhttppostmode = 4 && XML
oIP.nhttpport = this.nhttpport
oIP.nhttpconnecttype = this.nHTTPType
oIP.AddPostkey('',lcXML)
lcResults = oIP.HTTPGet(trim(this.cDataServerAddress),this.cDataUserName,this.cDatabasePassword)
locErrorMsg = oIP.cErrorMsg
Release oIP
*- if blank, didn't connect, otherwise it will be the file
*- returned from SQL Server
IF empty(lcResults)
this.cMessage = 'Upload failed: data transmission error. Make sure you are connected to the Internet and retry. ' + ;
'The error message is: ' + locErrorMsg
RETURN .F.
ELSE
THIS.cReturnXML = lcResults
Return .T.
ENDIF
**** end code ******
>Thanks - there was a lot of usefull information at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexxml/html/xml07162001.asp?frame=true> However, once I create the XMLUpdateGram, how do I issue a command in VFP that will send the UpdateGram to update the SQLServer table.