For Oracle database server

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;

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.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2022

August 21, 2023

Was this article helpful?