I sometimes use an I-descriptor to create a composite key in a sub-table made up from the Id of the mv-record and the position of the values in the array. i.e 123456*1 for the first set of values and 123456*2 for the second and so on. That way I get a unique key for every row. Or you could of course use REUSE(@ID) in your I-descriptor to get the Sales Order Number in each row.
-------- Original-Nachricht -------- > Datum: Tue, 28 Dec 2010 13:27:20 -0700 > Von: Jeff Schasny <[email protected]> > An: [email protected] > Betreff: [U2] ODBC, record IDs, I- Descriptors, and stuff > 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 -- NEU: FreePhone - kostenlos mobil telefonieren und surfen! Jetzt informieren: http://www.gmx.net/de/go/freephone _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
