If your application uses a non-Oracle database (for example, Microsoft SQL server) you can use the following SQL syntax to limit the number of returned rows to the DataWindow:
SELECT TOP 10 * FROM my_table WHERE Table.primary_key > = :bottom ORDER BY Table.primary_key;
Before retrieving the first page of data, "bottom" should be set to a value smaller than any primary key value in the table.
Based on this SQL statement, you can implement Next and Previous buttons for the DataWindow. Their Clicked events increment or decrement the "bottom" variable so that its value matches the primary key value in the first row you want to retrieve then execute the above SQL statement.
