Page 1 of 1
paging problem
Posted: Wed Oct 12, 2022 3:04 pm
by acroporax
Hi All,
I have 31 records, my "rows per page" parameter is set 20 record. But the form does not paginate.
also the rest of the records are not showing but when searching records are found.
https://ibb.co/HxbhyN0
https://ibb.co/P1g2d55
Re: paging problem
Posted: Wed Oct 12, 2022 3:30 pm
by kev1n
Hi,
Could you post the generated Browse SQL (CTRL+SHIFT+M)
and also the SQL that has been entered in the Browse SQL?
Re: paging problem
Posted: Thu Oct 13, 2022 11:29 am
by acroporax
Re: paging problem
Posted: Thu Oct 13, 2022 11:43 am
by kev1n
Thanks, could you also upload your table schema/structure?
e.g.
structure.png
Re: paging problem
Posted: Fri Oct 14, 2022 12:03 pm
by acroporax
Sorry,
My php version is old.
PHP 7.2.5+ is required.
Currently installed version is: 7.0.33-0+deb9u12
Re: paging problem
Posted: Fri Oct 14, 2022 12:37 pm
by acroporax
Problem is solved.
The Forms Display parameter value is 'Date' but the correct value should be date. So it had to be lowercase. Because it's lowercase in the table schema.