TablePlus-Windows
TablePlus-Windows copied to clipboard
Paging requires primary key and SQL Server 2012 (or above)
-
Which driver are you using and version of it (Ex: PostgreSQL 10.0): SQL Server 2014 (Express)
-
Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 174
-
The steps to reproduce this issue: Using SQL views you can only see the first "page" of results. Any attempt to go to the next page by pressing ">" brings up the error "Paging requires primary key and SQL Server 2012 (or above)" and entering in a different offset on the "Page Settings" gear icon does nothing, no error message but no change in displayed records. I'm sure there is some programming reason behind this, but it shouldn't be hard to add "OFFSET 500 ROWS FETCH NEXT 500 ROWS ONLY" to the query.
Thanks @rwhirn we're checking it