RE: Sort records in subfile

["Leisk, Andrew" <aleisk@xxxxxxxxxxx>]

Title: RE: Sort records in subfile

The below sounds like a great idea, however I might make on suggestion to make it run even faster.  Instead of using a temp physical file, you might try using a user index.  User Indexes are much faster than physical files for this kind of quick sorting.

----------
From:   End of the Trail[SMTP:endofthetrail@skyenet.net]
Reply To:       RPG400-L@midrange.com
Sent:   Tuesday, June 27, 2000 8:29 AM
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
+---