Author: email@example.com (George Mockford)
For sometime now I've been experimenting with data pagination using the database and perhaps more specifically modification of the Uniface 'where' clause. Some of you have contributed to this so it's not entirely new but with new stored procedure support in 9.5 for MSSQL I thought I'd share with you what I have done already plus a version specific for MSSQL that calls a stored procedure to 'page' through the database.
Arguably the concepts shown here should be a part of or within our drivers but perhaps if there is sufficient support maybe????
Even if you do not like the concept hopefully the code examples will provide some real examples of how this works but you can be the judge. I've included in the zip more details of what this contains and how it works.
Feedback as always is welcome. -George