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/
