Hello It's been a couple years since I was doing this, so the details are getting fuzzy. But as I recall, UniObjects provides a class that has a query method. You pass your uniquery command as a string to the Query method which returns the XML. Now, I forgotten what the mechanism was for converting the xml to a dataset object, but it's built in to either UniObjects or .net.
We found that besides the TOXML keyword, it was best to also always include the ELEMENTS keyword. With UniData, the default is to return the data as attributes. But the ELEMENTS keyword causes the data columns to be returned as elements. The main significance was that if your data set had a case where for a given field, none of the rows had a value in UniData, then that field was omitted from the xml results. So later, if your code referenced that column by name, you had an error condition to handle. The other point I remember is that it got slow with large data sets. By large I mean 50k+ rows of data. Most of the time (about 95%) is used in converting the uniquery results to xml then converting the XML to ADO. hth Victor St. Clair Sr. Analyst Jenkon [EMAIL PROTECTED] 360-256-4400 Phone 360-256-9623 Fax www.jenkon.com All information contained within this email is Confidential and Proprietary. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:14 PM To: [email protected] Subject: RE: [U2] UniSubroutine question >>In UO.NET I get my databasic to return xml - that way I can bind it to >>most any control. XML would be great. I am not sure about the syntax still. For example: LIST INVENTORY-MASTER WITH PART_TYPE = "5" PARTNUM DESCRIPTION TOXML This will list the XML to the screen. How do I capture the XML text and return it to the calling program? Also, my understanding is that you can generate DTD as well. Do you use this? If so, how do you capture the DTD? Also, in cases where something more complex is needed than a query, can XML be generated? Say you wanted to pull items from different files and do calculations, etc. Do you have to build dictionary attributes in all cases? Charles Shaffer Senior Analyst NTN-Bower Corporation ------- 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/
