For all other database servers

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 &gt; = :bottom 
ORDER BY Table.primary_key;

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.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2022

August 21, 2023

Was this article helpful?