Actually, WHEN works for a normal list as well. If you have multiple associated multi-valued fields, you can restrict which multivalues display using WHEN. For example:
LIST ORDERS ITEM QTY PRICE WHEN QTY GT 10 Assuming ITEM, QTY and PRICE are associated, the result will only show those lines whose quantity is greater than 10. To answer Russ's original question: I don't think UniVerse supports BETWEEN, but the following may work (it works in UniData): SELECT FILE WITH ANY QTY >= 1000 AND WITH ANY QTY <= 2000 The ANY keyword examines each value independently. If you use WITH QTY >= ... Then the entire QTY attribute (which may look like 2500}2500}300) is evaluated. HTH Larry Hiscock Western Computer Services -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, December 19, 2007 3:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] selection of multivalued field based on range WHEN only works with BY.EXP and is not associated with WITH . You can have bunches of WITH's, but only the first WHEN gets evaluated. At least with the versions I've worked with. And that's on Unidata! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 19, 2007 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2] selection of multivalued field based on range Allen, I am from a Unidata background. I am guessing that you work in Universe? I am curious about how Universe works. >> as only one WHEN per statement works. Does that mean you can only use one WHEN verb in a SELECT statement? In Unidata you can use multiple WITH (OR WHEN) verbs in a statement. Example. SELECT WIP-BATCH-DETAIL-HIST_MA WITH WORK.DATE >= "10/1/07" AND WITH WORK.DATE <= "10/31/07" I believe it was the same in the old PICK days. Anyone remember Ultimate PICK? It was OK, but it didn't live up to its name. Charles Shaffer Senior Analyst NTN-Bower Corporation ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
