RE: Sort records in subfile

Do you have an example of how to code this technique, that you could share?

TIA...




|--------+----------------------->
|        |          TUCKERG@techn|
|        |          icolor.com   |
|        |                       |
|        |          06/27/2000   |
|        |          10:51 AM     |
|        |          Please       |
|        |          respond to   |
|        |          RPG400-L     |
|        |                       |
|--------+----------------------->
  >--------------------------------------------------------|
  |                                                        |
  |       To:     RPG400-L@midrange.com                    |
  |       cc:     (bcc: Darlene H Bryant/Banpharm)         |
  |       Subject:     RE: Sort records in subfile         |
  >--------------------------------------------------------|






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
+---



+---
| 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
+---