We have just migrated from UV 10.1 to UV 10.2.7 and found we get different results from a query producing XML. Unfortunately we have built our consuming client around the desirable original behaviour, but fortunately this project is not yet in production. Does anyone know how we can get this behaviour back.
We are creating XML to send a number of "codesets" from the same reference file. Each of these has its own item name within the reference file. The general format of the query was as follows. SELECT CODE , DISPLAY FROM REF.CODES_XML AS "TABLE_GENDER" WHERE @ID = 'GENDER' ORDER BY CODE TOXML; Note the AS "TABLE_GENDER" This gave us a node within the XML called <TABLE_GENDER> which surrounded the data for this item <ROOT> <REF.CODES_XML> <TABLE_GENDER> .... </TABLE_GENDER> Under 10.2.7 the <TABLE_GENDER> node is not present. I originally found this syntax in one of the many pdfs on this subject but I cannot find it now. The documentation for the new features being incorporated in 10+ versions is becoming very difficult to manage. I hope there is some plan to incorporate these into the on-line help. Any suggestions would be appreciated Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
