Oracle includes a pseudo-column called ROWNUM which allows you to generate a list of sequential numbers based on ordinal row. If your application uses the Oracle database, apply your Oracle skills and ROWNUM to limit the number of returned rows. For example, this query selects the 10 rows from a table:
SELECT * FROM (SELECT rownum r, t_dwstyle_grid_employ.empid FROM t_dwstyle_grid_employ) WHERE r BETWEEN 10 AND 20;
You can impose a NEXT button to the DataWindow. In the Clicked event of the NEXT button, the query changes with ROWNUM which increments by 10. Therefore, when the NEXT button is clicked, the DataWindow displays the next 10 rows.
