CREATE CURSOR myWebPage (content m) url="http://www.whereever.intra/datamanagement/tblMSDSXML.aspx" objHTTP = CreateObject("MSXML2.XMLHTTP") objHTTP.Open("GET", url,.f.) objHTTP.Send() Insert into myWebPage (content) VALUES (objHTTP.ResponseText) MODIFY MEMO myWebPage.content>I want to fetch the result of a webpage (XML) and process it in VFP. I have therefor done the following:
>oIE = CREATEOBJECT("InternetExplorer.Application") >oIE.Navigate("http://www.whereever.intra/datamanagement/tblMSDSXML.aspx") > >INKEY(1) >nStartSeconds = SECONDS() >DO WHILE oIE.Document.ReadyState <> "complete" AND (SECONDS()-nStartSeconds < 30) >ENDDO > >IF oIE.Document.ReadyState <> "complete" > MESSAGEBOX("Page was not retrieved") > oie.Visible = .T. > RETURN .F. >ELSE > SET STEP ON > oie.Visible = .T. > * and now what? How can I read what the browser is now showing >ENDIF >>