RE: Sort records in subfile

[TUCKERG@xxxxxxxxxxxxxxx]

This technique is one that I use as well as it's similar to several Windows
applications that people are familiar with and also the Work With Active
Jobs display.  Rather than use a work file though I use arrays as they tend
(at least in ILE) to have a lower overhead when compared with work file I/O.

Regards,

Gerry

> -----Original Message-----
> From: End of the Trail [SMTP:endofthetrail@skyenet.net]
> Sent: Tuesday, June 27, 2000 2:30 PM
> To:   RPG400-L@midrange.com
> Subject:      Re: Sort records in subfile
> 
> What I have done, is after loading the subfile.  Is to allow the user to
> position the cursor on the header(title line) of any column, retreive the
> position(column) after enter is press, write the subfile to a keyed, tmp,
> wrk, file.  [The file is laid out like the subfile with a extra key field.
> The key is a large alpha field (the size of the largest field you will
> allow
> to be sorted) ]  Fill the key with the data field from the column to be
> sorted.  Populate the all fields in the file.  Clear and reload the
> subfile
> from the tmp/wrk file.   This rountine usually runs pretty fast, but it
> will
> depend on the subfile size and the machine.
> 
> I like using the cursor position and subfile record postion in many of my
> inquiry programs.  The user, if using Client Access and setup correctly,
> will be able to use their mouse.  When coded with this in mind, you can
> give
> a "window/PC" feel better easily.   The user points to the title line,
> double clicks, which emulates moving the cursor and pressing enter which
> calls the sort routine.  I also allow them to double-click on a subfile
> record which may call a detail inquiry screen, print routine or any other
> needed rountine.
> 
> Anyhow....   That is my 2 cents...
> 
> Eurrat Saylor, Jr
> 9562 East  750 North
> Walkerton (Koontz Lake), IN  46574
> 219-586-7970  tel
> 219-586-2677  fax
> 
> -----Original Message-----
> From: Timura, Patrik (CAP, GCF) <Patrik.Timura@gecapital.com>
> To: 'RPG400-L@midrange.com' <RPG400-L@midrange.com>
> Date: Tuesday, June 27, 2000 7:31 AM
> Subject: Sort records in subfile
> 
> 
> >Hi all :-)
> >
> >How are you doing today ?
> >
> >I have a question - is any possibility to sort records in the subfile ? I
> am
> >trying to give to user chance, when listing in a subfile, to see the
> records
> >sorted ...
> >
> >any suggestions ?
> >
> >Thank you and wish a nice day :-)
> >+---
> >| 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
> +---
+---
| 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
+---