... * Create cursor with proper field types by replacing '-' with '0' XMLTOCURSOR(STRTRAN(cXML, "-", "0"), "crsXml") * Actual XML conversion into already created cursor SELECT crsXml ZAP XMLTOCURSOR(cXML, "crsXml",8192) ?"number1:", VARTYPE(number1) && "N" ?"number2:", VARTYPE(number2) && "N">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?
** 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" >>