RE: Changing sorting criteria

Rob,

Sure with a QMFORM you can set the USAGE of a column to *OMIT.


Note: a trick if you ever want to *OMIT a *BREAK column.  Stick a blank on the 
front of the value and make the column your last SELECTed.  Then in the QMFORM, 
you force the column's width to 1, and indention to 0.


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
> Sent: Thursday, August 04, 2005 3:23 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL: Changing sorting criteria
> 
> 
> Given the following QMQRY:
> 
> Select MNUser, MNName, MNOpt#, MNTitl, MNDesc, MNPgm, MNCmd, MNNew,
> case MNName 
>   when 'MAIN' then 'A' 
>   else MNName 
> end as sorter 
> from menu3pf 
> order by MNUser, Sorter, MNOpt# 
> 
> which sorts 'MAIN' before 'ACCT01'
> 
> is there a way to not display SORTER?  So far, I've not bothered with 
> QMFORM's.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>