Hello I'm working on a project using C# with UO.net with UniData 7.1 on Win2003 Server. I'm trying to use the uniXML class to retrieve an XML document from a set of associated fields in a single file. When I run the query I get a result of
IBMU2.UODOTNET.UniXMLException Schema: global element: 'WEB_CNTRYS-MV" declared more than once. The file I'm running against has 8 fields defined in the association named WEB_CNTRYS. I can use list on them from TCL and the data displays fine. However, if I add TOXML to export the results to XML I get funny results, as follows: List FILENAME WITH @ID = "RECORDNAME", WEB_EMP_IDS WEB_EMP_CNTRYS WEB_EMP_CNTRY_NAMES WEB_EMP_CNTRY_OPER_CULTURE CNTY_REQD_FLG ST_REQD_FLG ZIP_FLG TOXML The results look like this: <?xml version="1.0"?> <ROOT> <NETCONTROL_SQL _ID = "WEB.MASTER"> <WEB_CNTRYS-MV WEB_EMP_IDS = "WEB" WEB_EMP_CNTRYS = "USA" WEB_EMP_CNTRY_NAMES = "U.s.a"/> <WEB_CNTRYS-MV WEB_EMP_IDS = "WEB_CAN" WEB_EMP_CNTRYS = "CAN" WEB_EMP_CNTRY_NA MES = "Canada"/> <WEB_CNTRYS-MV WEB_EMP_IDS = "WEB_FR" WEB_EMP_CNTRYS = "FR" WEB_EMP_CNTRY_NAME S = "France"/> <WEB_CNTRYS-MV WEB_EMP_IDS = "WEB_AU" WEB_EMP_CNTRYS = "AU" WEB_EMP_CNTRY_NAME S = "Australia"/> <WEB_CNTRYS-MV WEB_EMP_IDS = "WEB_NZ" WEB_EMP_CNTRYS = "NZ" WEB_EMP_CNTRY_NAME S = "New Zealand"/> <WEB_CNTRYS-MV WEB_EMP_CNTRY_OPER_CULTURE = "en-US"/> <WEB_CNTRYS-MV WEB_EMP_CNTRY_OPER_CULTURE = "en-CA"/> <WEB_CNTRYS-MV WEB_EMP_CNTRY_OPER_CULTURE = "fr-FR"/> <WEB_CNTRYS-MV WEB_EMP_CNTRY_OPER_CULTURE = "en-CA"/> <WEB_CNTRYS-MV WEB_EMP_CNTRY_OPER_CULTURE = "en-CA"/> <WEB_CNTRYS-MV CNTY_REQD_FLG = "Y"/> <WEB_CNTRYS-MV CNTY_REQD_FLG = "N"/> <WEB_CNTRYS-MV CNTY_REQD_FLG = "N"/> <WEB_CNTRYS-MV CNTY_REQD_FLG = "N"/> <WEB_CNTRYS-MV CNTY_REQD_FLG = "N"/> <WEB_CNTRYS-MV ST_REQD_FLG = "Y"/> <WEB_CNTRYS-MV ST_REQD_FLG = "Y"/> <WEB_CNTRYS-MV ST_REQD_FLG = "N"/> <WEB_CNTRYS-MV ST_REQD_FLG = "N"/> <WEB_CNTRYS-MV ST_REQD_FLG = "N"/> <WEB_CNTRYS-MV ZIP_FLG = "Y"/> <WEB_CNTRYS-MV ZIP_FLG = "N"/> <WEB_CNTRYS-MV ZIP_FLG = "N"/> <WEB_CNTRYS-MV ZIP_FLG = "N"/> <WEB_CNTRYS-MV ZIP_FLG = "N"/> </NETCONTROL_SQL> </ROOT> In the example, all seven of the fields are multi-valued. Our ECLTYPE is normally P, but I've tried the above command with lower case 'list' to get type U as well. (I've tried it both ways, same results). Can any one shed any light on what's going on or suggest things I can try or look into? Has any one seen this happen? Thanks Victor St. Clair Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
