RE: Inserting a record into the middle of a subfile--suggestions?

And, thank you to Alan for the lead to QSORT
I found Jon Paris' IT Jungle article "qsort: A Better SORTA" which helped me understand the power of Alan's suggestion . . .

Happy New Year to 'the list' !

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Tuesday, December 30, 2014 9:45 AM
To: Midrange Systems Technical Discussion
Subject: Re: Inserting a record into the middle of a subfile--suggestions?

If you are looking to dynamically sort data from a subfile, you can go to www.think400.dk/downloads.htm and look for a utility called XVSRTQ.

This API allows you to build keys and sort data dynamically. It uses QSORT to do the actual sorting. Basically a wrapper around an array that gets sorted. The good thing about the utility is that it knows how to store data correctly for sorting. Everything is handled by the API. Plus its free.
That best price of all.

On Tue, Dec 30, 2014 at 9:14 AM, Jeff Young <jyoung0950@xxxxxxxxx> wrote:

Gary,
Thanks for mentioning the article by Paul Tuohy.
I now have another tool in my tool box.

Jeff Young
Sr. Programmer Analyst

On Mon, Dec 29, 2014 at 4:57 PM, Gary Thompson <gthompson@xxxxxxxxxxx>
wrote:

I have a couple of applications that do something similar: copying a
subfile to an array, re-numbering and re-sorting and the performance
is good.

The sorting is flexible, based on an article by Paul Tuohy: "Those
Weird and Wonderful Arrays" and uses a pointer to switch between the
appropriate data structure depending on what the user is doing.

If you are below a couple hundred records I expect you'll get good

results.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of Hoteltravelfundotcom
Sent: Monday, December 29, 2014 2:43 PM
To: Midrange Systems Technical Discussion
Subject: Re: Inserting a record into the middle of a

subfile--suggestions?

copying to variable size array. why not also have the user have an
edit mode screen' of the row to be updated?

On Mon, Dec 29, 2014 at 4:39 PM, x y <xy6581@xxxxxxxxx> wrote:

I need to insert records into the middle of a subfile. The user
can enter a keyword that's attached to a long description and I
need to get that description into the body of the subfile.

I could add records to the end and then resequence when writing to
the database but that won't be satisfactory from a user experience
perspective--the user needs to see the full text in order as part
of the entry process. My subfile record length (including hidden
fields) is about
400 bytes and I should have less that 50 records most of the time.
I have four 132-character subfile records on the screen and
already have used the fold/unfold option.

Copying the subfile to a variable-size array, inserting the
records where needed, and then reloading the subfile is an option.

Another option is to have A/B subfile control/detail set up
records copy from the "A" subfile (+ inserts) into the "B" subfile
and then display the "B" control record. SQL temporary tables and
memory-resident tables are possibilities also.

Where's a linked list when we really need it?

I'll be grateful for any suggestions and wish you all a Happy New Year.

thx...
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.