i have a table with over 10000 records;
i don't want execute a unique "select * from tablename....." but
i am able to create a classic "pagination"
exemple:
<< first page | < previous one | >next one | >> last page
and with sql query "select * from tablename ....... limit 5, maxRows"
maxRows indicate a max number of rows for page of table (TableView or B4XTable)
how to calculate a max number of table (for single page) when user resize a form/layout ?
i don't want execute a unique "select * from tablename....." but
i am able to create a classic "pagination"
exemple:
<< first page | < previous one | >next one | >> last page
and with sql query "select * from tablename ....... limit 5, maxRows"
maxRows indicate a max number of rows for page of table (TableView or B4XTable)
how to calculate a max number of table (for single page) when user resize a form/layout ?