Hi Bo,

If you know the structure of the XML, you can add a switch to the XMLTOCURSOR command and use an existing cursor

CREATE CURSOR yourcusrsor (number1 y, number2 y)
lnXmlRecords=XMLTOCURSOR('yourxml.xml','yourcursur',512+8192)

>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