Re: main difference between expandable and singlepage subfile

[Nathan Andelin <nandelin@xxxxxxxxx>]

The database maintenance design pattern that I follow (almost religiously)
is the use of a browser component that is based on an HTML table (except it
also implements row navigation and selection via keyboard and mouse event
handlers, which facilitate database operations such as copy, change, and
delete). On the server, we implement scrollable cursors via SQL. In the
browser we implement a scrollable list that asynchronously syncs with the
scrollable cursor on the server. Provide column sorting. Provide a dialog
for filtering the list. As users navigate from row to row in the list, the
complete record is automatically and asynchronously retrieved from the
server via an RLA operation, and shown in a panel which is placed above, or
aside the list. Keyboard and mouse event handlers toggle the UI between
add, copy, change, and delete modes.


On Tue, Dec 31, 2019 at 11:38 AM Booth Martin <booth@xxxxxxxxxxxx> wrote:

> OK.  I like that.
>
> Question:  we're using one of these new & spiffy solutions. We want to
> provide the same function as our antiquated 5250 subfile but jazz it up
> with that modern stuff. And we have a 1,600,000 row DB/2 table.  What
> steps, generally, do we do differently than we'd do with a 5250 solution?