User talk:Foxsoft

XML Parsing Issue. Can anyone assist. ? Recent development requires that we parse a standard XML file using VFP8 or VFP9. Using Foxpro XMLCURSOR we encounter issues when parsing datetime fields which carry the 'Z' (timezone) marker If the Z is there then a character field is created in the resulting cursor, remove the market the data is parsed correctly as datetime.

Could anyone shed light on why this occur's and what if anything I can do about it ? a sample of the xml file (with zone marker) is below.

Thanks for any help you can offer? Foxsoft (talk) 15:57, 1 May 2009 (UTC)

 2009-04-29T16:27:02Z 1 1 1 2009-04-29T16:27:02Z 2009-04-29T16:27:16Z 2 2 2</id> <updated_at type="datetime">2009-04-29T16:27:16Z</updated_at> <created_at type="datetime">2009-04-29T16:27:26Z</created_at> <foxpro_claimno type="integer">3</foxpro_claimno> <foxpro_id type="integer">3</foxpro_id> 3</id> <updated_at type="datetime">2009-04-29T16:27:26Z</updated_at> <created_at type="datetime">2009-04-29T16:27:34Z</created_at> <foxpro_claimno type="integer">4</foxpro_claimno> <foxpro_id type="integer">4</foxpro_id> 4</id> <updated_at type="datetime">2009-04-29T16:27:34Z</updated_at>