I have a sales order file which I am accessing via UniObjects in a MS Visual Studio application. I would like to populate a data bound ListView control in the application with the multivalued sku, description, size and quantity for a given sales order. I have successfully created the data binding to the table via ODBC in the application, however, since the multivalued data set is presented in ODBC as a separate table (SALES.ORDER.PRODUCT) which does not contain a reference to the SALES ORDER table ID I can not "select where sales.order.id = whatever". I tried creating a multivalued I descriptor referencing @id and making it part of the associated multivalued association phrase and the @ and @select phrases but it only returns a single value.

What can I do to get a SALES.ORDER id for every line in SALES.ORDER.PRODUCT so that I can select only the data I need?

--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to