Bernardo,

Yes, if they drag the scroll bar to the bottom of the grid it will have to retrieve the entire view.

If your grid has say 20 rows visible, I think you can have your button just do a SKIP 20 to pull the next 20 rows of data down?

>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?