When I use the XMLTOCURSOR function and the XML contains a negative number, it creates a field type of character instead of number. What is the easiest way of getting around this?

I know the element names and data types of the XML, but not necessarily the precision of the number types. I guess I could create an external schema but where do you find the schema specifications?

** Sample:

LOCAL cXML
** Create sample XML
TEXT TO cXML NOSHOW
<data>
	<record>
		<number1> 100.00</number1>
		<number2>-100.00</number2>
	</record>
</data>
ENDTEXT

XMLTOCURSOR(cXML)
?"number1:", VARTYPE(number1)	&& "N"
?"number2:", VARTYPE(number2)	&& "C"

Thanks,
Bo Durban