RE: Secondary Keys

Big file. It's a product routings file.

Patrick Conner
www.ConnecTown.com
(828) 244-0822



                                                                                
               
                    Joel Fritz                                                  
               
                    <JFritz@sharperim        To:     "'RPG400-L@midrange.com'"  
               
                    age.com>                 <RPG400-L@midrange.com>            
               
                    Sent by:                 cc:                                
               
                    owner-rpg400-l@mi        Subject:     RE: Secondary Keys    
               
                    drange.com                                                  
               
                                                                                
               
                                                                                
               
                    12/06/00 12:32 PM                                           
               
                    Please respond to                                           
               
                    RPG400-L                                                    
               
                                                                                
               
                                                                                
               




If the information on the screen contains a relatively small number of
records, you could load the subfile from an array with overlays and sort on
the subfields.  This gives you the potential ability to sort the subfile on
any column or group of contiguous columns.

> -----Original Message-----
> From: Contractor1@Parkdalemills.com
> [mailto:Contractor1@Parkdalemills.com]
> Sent: Wednesday, December 06, 2000 7:26 AM
> To: RPG400-L@midrange.com
> Subject: Secondary Keys
>
>
>
> I have a maintenance program that can be displayed with
> multiple sorts. It
> is set up to read different a logical based on what the user
> keys as a sort
> code. However, some information in the subfile is from
> secondary files and
> they want the subfile sorted on those fields. I looked at doing a join
> logical, but I can't tell where I'm allowed to use the fields from the
> secondary file as key fields. Anyone have any suggestions?
>
> Patrick Conner
> www.ConnecTown.com
> (828) 244-0822
>
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---