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