RE: What's wrong with this XML that VFP barfs?

Author: Derek J. Kalweit

Posted: 2004-04-01 at 11:39:01

> >><DirectLine>570.385.7600</DirectLine>

> >>Here's the error:

> >>http://mbsoftwaresolutions.com/images/xmlerror.JPG

> >>

> >>Everything seems to have a closing tag, yet it doesn't like the

> >>DirectLine for some reason. Perhaps someone can see what I

> am not???

> > It looks like VFP might be trying to interpret the

> DirectLine value as a numeric, and it's choking on two decimal points.

> Looks like you're right...I'll mandate the dashes instead of the

> periods....thanks a million, Derek!

I would report it as a bug to Microsoft, as well. VFP should be smart enough to know that a 'number' with two decimals is actually a string-- the data type matching code should be easy enough to change to 'must be ONLY ONE decimal point'...

If you were using an XSD schema, I believe this would have worked as it should. I've never used an XSD schema with XMLTOCURSOR(), but I believe it's possible... I really don't use XMLTOCURSOR() that much, as I rarely have XML data that simple...

--

Derek

©2004 Derek J. Kalweit