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.