Re: Subfile more/bottom problem

Next question: ( thank you for this discussion, btw)

why a page of records plus one? What is the "plus one" for?

On 1/15/2014 3:51 PM, Alan Campin wrote:

I agree. I just wrote a set of subfiles with single page load in
procedures, 5 different position to values using dynamic SQL. Very simple
and clean. The dynamic SQL makes it simple and reading everything in a
single read into an array makes it even simpler. Only one procedure

builds

the SQL statement and opens the cursor. All the rest of the routines just
read the cursor reading a page of records plus one into an array.

Framework

can be used again and again, just changing the load procedures.

--
Booth Martin
www.martinvt.com
(802)461-5349
Skype: booth.martin

Ken Thompson has an automobile which he helped design. Unlike most
automobiles, it has neither speedometer, nor gas gage, nor any of the
numerous idiot lights which plague the modern driver. Rather, if the
driver makes any mistake, a giant "?" lights up in the center of the
dashboard. "The experienced driver", he says, "will usually know what's
wrong."
--
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: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.