objHTTP = .null.

>Mike
>
>It works well but I have 1 last question - if I don't close the process I can't update the view without exiting VFP - how do I close it?
>
>Colin
>
>
>>

CREATE CURSOR myWebPage (content m)
>>url="http://www.timeanddate.com/worldclock/full.html"
>>objHTTP = CreateObject("MSXML2.XMLHTTP")
>>objHTTP.Open("GET", url,.f.)
>>objHTTP.Send()
>>Insert into myWebPage (content) VALUES (objHTTP.ResponseText)
>>MODIFY MEMO myWebPage.content

>>
>>>Mike
>>>
>>>Sounds good but how do I code the internet query from VFP6?
>>>
>>>>Do a query on this internet site, parse the page and do the calculation. This page gives you the current date and time for most places in the world.
>>>>http://www.timeanddate.com/worldclock/full.html
>>>>
>>>>>Local computer is based in the UK - it needs to know what the local time is in Chicago where the package is going
>>>>>
>>>>>Colin
>>>>>
>>>>>>Wouldn't the local computer where the application is installed know the offset to GMT?
>>>>>>

On Error *
>>>>>>lcComputer = "."
>>>>>>loWMIService = Getobject("winmgmts:\\" + lcComputer + "\root\cimv2")
>>>>>>colItems = loWMIService.ExecQuery("Select * from Win32_TimeZone")
>>>>>>For Each loItem In colItems
>>>>>>	?"Bias: " + transf(loItem.Bias)  && Offset in minutes
>>>>>>	?"Caption: " + transf(loItem.Caption) && Description of the setting
>>>>>>	?"Daylight Bias: " + transf(loItem.DaylightBias)  && Daylight savings time setting
>>>>>>	?"Description: " + transf(loItem.Description) && Description of the setting
>>>>>>	?
>>>>>>Next

>>>>>>
>>>>>>Or you can use the GETSYSTEMTIME() (GMT time) and make the diffence against the GETLOCALTIME() API to get the offset to GMT.
>>>>>>
>>>>>>>Hi
>>>>>>>
>>>>>>>I have a database which contains information about packages to be delivered all over the world - I want to be able to find out the local time at destination without having to calculate it manually
>>>>>>>
>>>>>>>So for example if I have a package to be delivered to Chicago I can automatically calulate that the time difference is 6 hours behind the UK
>>>>>>>
>>>>>>>Anyone ever done any work in this area?
>>>>>>>
>>>>>>>Thanks
>>>>>>>
>>>>>>>Colin