Hello David Thanks for the suggestion. I'd tried various ways of manipulating the dictionaries, but didn't try that. In fact, on thinking about it further, I'm not sure I know how to do what you're suggesting. Would you mind elaborating just a bit more?
Victor -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A. Green Sent: Tuesday, January 17, 2006 6:15 AM To: [email protected] Subject: RE: [U2] XML with UO7.1 How about a Virtual Attribute that reproduces the Single Valued items for the number of Multi-Values. Then add it to your Association. Thanks, David A. Green DAG Consulting -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor St Clair Sent: Monday, January 16, 2006 10:27 AM To: [email protected] Subject: [U2] XML with UO7.1 I'm working on a project using C# with UO.net with UniData 7.1 on Win2003 Server. I'm using the uniXML class to retrieve an XML document from which includes both single-value and multi-value columns. I then convert the XML to a dataset. I'm ending up with two tables in my data set. The first table holds the single-value fields, the second table all the multi-value fields. The name of the second table is always AssociationName-MV. Example MyFile: <1> myAttribute1 someAtt <2> myAttribute2 someValue1]someValue2 <3> myAttribute3 someValue1]someValue2 With a query like 'list MyFile myAttribute1 myAttribute2 myAttribute3 ID.SUPP TOXML Assumming myAttribute2 and myAttribute3 are in an association named myAssoc I currently get the following <MyFile myAttribute1 = someAtt> <myAssoc-MV myAttribute2=someValue1, myAttribute3=someValue1/> <myAssoc-MV myAttribute2=someValue2, myAttribute3=someValue2/> I would like to get an XML document something like: <MyFile myAttribute1 = someAtt, myAttribute2=someValue1, myAttribute3=someValue1/> <MyFile myAttribute1 = someAtt, myAttribute2=someValue2, myAttribute3=someValue2/> So far I've been able to use the default XML created by UniData without having to setup any mapping files. I'm hoping there is a way to accomplish this without using the mapping files. Is there a way to create a UniQuery statement that will flatten out the results before the XML document is created? Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
