S
SJaka
Guest
We are using an older character based version of QAD's MFG/PRO running on Progress version 10.1. On one of the shipping tables, I've to create a browse that will display all records in a scrollable browse (sort of infinite scroll browse). It will display first 10 records initially, but user will be able to scroll up or down in the browse, which should load previous or next record (up or down arrow key).
I was wondering how something like this can be achieved. Preloading a temp-table with hundreds of thousands of records doesn't seem like a good way to do it, querying the database for every up or down arrow key press sounds equally bad.
Also, how the scenario would change if instead of a browse showing data from a single table, will combine data from multiple tables?
Any help/pointers in this regard will be helpful. Also, if some best practices can be shared.
Continue reading...
I was wondering how something like this can be achieved. Preloading a temp-table with hundreds of thousands of records doesn't seem like a good way to do it, querying the database for every up or down arrow key press sounds equally bad.
Also, how the scenario would change if instead of a browse showing data from a single table, will combine data from multiple tables?
Any help/pointers in this regard will be helpful. Also, if some best practices can be shared.
Continue reading...