Re: Looking for Skeleton RPG program

Not always - no.

I have seen end users waste a lot of time searching through subfiles looking for a value that no longer exists because of updates to the database.

I came to the conclusion that once a subfile value is displayed it should not be changed unless the user asks for it. When a user requests a query be sequenced on a particular key they are, in my opinion, asking for the data that they are looking at to be presented in a new sequence - not for a new query.

This is surely the way that most browser apps work these days where the data is sorted within the page. The user gets a refresh when they ask for it.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Jan 9, 2018, at 8:18 AM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

This is very simple.

Any subfile should reflect the data in the DB as resent as possible.
Loading e.g. 100.000
records and pageing through the subfile in hours without reloading the data
from the DB
is a bad solution because one will work on a copy created on load time.

Refreshing the subfile (pressing F5) will either cause the sub-file to be
positioned at
the top/buttom or will require additional coding to positioning the subfile
where one where at
the time for the refresh.

So reading one subfile page at a time will most likely show real time data
and isn't it
what it is all about?

<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virusfri.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Jan 9, 2018 at 2:08 PM, <JRusling@xxxxxxxxxxx> wrote:

+ 1 but with the 'page-forward type subfile', fills the bill for most
anything i've needed for years. (with position to)

John

+1

- We only use page at a time subfile

<br />
The information in this email is confidential and may be legally
privileged.
It is intended solely for the addressee. Access to this email by anyone
else is
unauthorized. If you are not the intended recipient, any disclosure,
copying,
distribution or any action taken or omitted to be taken in reliance on it,
is
prohibited and may be unlawful.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
Regards,
Henrik Rützou

http://powerEXT.org <http://powerext.org/>
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD