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 thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].