Hi Ed, Yes, you need to use WHEN. If the dict items are not associated WHEN will be of no use.
SORT ORDER.FILE BY-EXP MODEL "XYZ" BREAK-ON MODEL TOTAL QTY WHEN MODEL EQ "XYZ" hth, Allen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Wednesday, September 14, 2005 18:02 To: '[email protected]' Subject: [U2] BY-EXP criteria in ecltype 'u' We are on UniData 6.1 and our ecltype is 'p'. I'm sure we are all familiar with a query like this: SORT ORDER.FILE BY-EXP MODEL BREAK-ON MODEL TOTAL QTY PRICE TOTAL EXT If I want to run the above query for a specific model or models, I can do something like this: SORT ORDER.FILE BY-EXP MODEL "ABC" "XYZ" BREAK-ON MODEL TOTAL QTY This will not only explode the MODEL attribute, it will return only values where the MODEL is equal to "ABC" or "XYZ". This works (I think) because we are running ecltype 'p' (pick). When we need to do a query that takes advantage of nice UniData stuff like COL.HDG, FMT, CNV, etc, we write it so our SORT or LIST is in lower case. Like this: sort ORDER.FILE BY.EXP MODEL BREAK.ON MODEL TOTAL QTY * However * If I want to run the lower case "sort" with the BY.EXP criteria, it doesn't work for me. I've tried: sort ORDER.FILE BY.EXP MODEL "XYZ" BREAK.ON MODEL TOTAL QTY No records listed. The following record ids do not exist: XYZ (EOF)Enter h for help, <CR> for next page and I've tried: sort ORDER.FILE BY.EXP MODEL = "XYZ" BREAK.ON MODEL TOTAL QTY --------------------------------^ syntax error Has anyone run into this? Do I need to play with "WHEN" and "ASSOCIATED"? Thanks in advance. Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] ______________________________________________________________________ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. ______________________________________________________________________ ------- 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/
