SORT command

GCC Consulting gccconsulting at comcast.net
Mon Aug 28 14:05:25 PDT 2006


 

> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of Doug Luurs
> Sent: Monday, August 28, 2006 4:48 PM
> To: filepro-list at lists.celestial.com
> Subject: SORT command
> 
> Question:
> 	Does the SORT command within Sort/Selection processing 
> need to be done once,
> 	or on each 'SELECT'ion ? 
>  
> Trying to change a sort for one report without having to 
> create the same report Report 2 times with different sorts.
> 
> Thanks
> ________________________________
> 
>  
> Douglas Luurs
>   Systems Programmer
>   Borisch Mfg Corp
>  
> Voice: 616-554-9820 x143
> Fax: 616-554-9180
> 
> If replying to this email, please attach whole message for 
> reference. - Thank You.

You can have different sorts in -v processing.  Just a variable to select
the sort criteria to use for the report.

You could do this on the command line if you are using different menu
options.  Set -r xxx or -r yyy and

If @pm = "xxx"
Then: sort1=1;end

If: @pm= "yyy"
Then: sort1=2;end

Or you can prompt for it at @once processing.  Use either menu or a listbox
with the available sorts and then run the process.  If you do it this way,
you could get your selection criteria also.

You could do this as a library function using clerk to gather the wanted
information, with the advantage of having browse lookups available where
needed for a selection criteria.  Then build the command line and use system
to run the output.

Richard Kreiss
GCC Consulting
   





More information about the Filepro-list mailing list