Richard Guelzow
Programmer
Hello All - I am querying an online database[non-vfp] using an HTTP Get Call. The 1st query works properly and returns the current status of the online database. Each subsequent call to the database returns the data from the initial call despite the fact that the underlying data in the online database has changed. The only way that I am able to obtain refreshed data is to exit VFP and restart the application. I have tried releasing the Microsoft.XMLHTTP object and re-creating it. I have tried releasing the local variable that the HTTP object is tried to. So far nothing has helped, I keep receiving the cached data from the initial query. Here is my code as entered into the VFP Command box:
m.oHTTP = CREATEOBJECT('Microsoft.XMLHTTP')
m.oHTTP.Open("GET", ' .F.)
m.oHTTP.Send()
m.cResult = oHTTP.responseText()
? XMLTOCURSOR(m.cResult,'Smscursor',0)
Thanks in advance.
Richard
m.oHTTP = CREATEOBJECT('Microsoft.XMLHTTP')
m.oHTTP.Open("GET", ' .F.)
m.oHTTP.Send()
m.cResult = oHTTP.responseText()
? XMLTOCURSOR(m.cResult,'Smscursor',0)
Thanks in advance.
Richard