Thanks. And thanks for pointing out that FMT does not need a particular ECLTYPE. I tried it and it worked, however, I could not get CNV to work under ECLTYPE=P.
-----Original Message----- From: Keith W. Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 5:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] BY-EXP criteria in ecltype 'u' I haven't played with this in UniData yet, but in UniVerse I would use both WITH (to limit the selection) and WHEN (to limit the values shown): SORT ORDER.FILE WITH MODEL = "ABC" "XYZ" BY-EXP MODEL WHEN MODEL = "ABC" "XYZ" BREAK-ON MODEL TOTAL QTY According to UniData HELP, FMT and CNV don't require any particular ECLTYPE, but WHEN requires ECLTYPE=U. -Keith > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Burwell, Edward > Sent: Wednesday, September 14, 2005 6:02 PM > To: 'u2-users@listserver.u2ug.org' > 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 > 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/ ______________________________________________________________________ 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. ______________________________________________________________________ ______________________________________________________________________ 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/