For this install, uv9.6 (Ideal flavor), that doesn't do it. The second select is ignored as far as the active list is concerned.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Tuesday, April 12, 2005 4:34 PM To: [email protected] Subject: RE: [U2] [UV] Select returning mv'd list Many times I've done this with two select statements. SELECT FILE KEY SELECT FILE MV.FIELD LIST FILE.TWO Most often this is how I get a list of detail records from a header record. BobW > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Kevin King > Sent: Tuesday, April 12, 2005 4:02 PM > To: [email protected] > Subject: [U2] [UV] Select returning mv'd list > > Universe 9.6, I want to select a record from a file and return a mv'd > list of information in attribute 1, each attribute as a separate list > element. On Unidata, I can: > > SELECT FILE.A 'key' F1 > > ...and it'll return all the values in F1 as individual items in the > active select list. On Universe, this does not work. So I tried: > > SELECT FILE.A 'key' SAVING UNIQUE F1 > > ...and I get all the items, but they come in one attribute, mv'd, not > split out on each line like Unidata would. > > I've also tried QSELECT, but apparently the option to QSELECT a single > attribute from a file is not supported here here. > > How do you select a record from a file and return a mv'd list from an > attribute in that record? > > -Kevin > HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] > http://www.PrecisOnline.com > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 > ------- > 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
