I have a SQL table a few thousands records, a remote view is linked to this table
With fetch as need set on and it works.

Here are some questions:

IF the user uses the scroll bar on the grid and take it to the bottom. The view tries to retrieve all the records (as opposed to retrieving the next batch only) how to prevent this.


If I remove the scroll bar I’d like to implement a button to retrieve next set.
Is it possible to use SQLMORERESULTS( ) with a view and a connection defined on the DBC.?

Not only do I need to remove the scrolls bars but also a way to prevent re retrieval os more records with “page down”, “down arrow” etc.

How to control this?