I created a simple table with 3 fields, id, code, name and inserted with 100 records for page query testing.
I tested on Mysql and Sqlite, the pagination work fine.
But for MSSQL 2019 & 2012 which I have used for testing, the pagination has no response and via debug screen, below is the error message
offset @p0 rows fetch next @p1 rows only - invalid usage of the option next in the fetch statement
Is this a Bug of wappler or MSSQL? Anyone can help?