TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Paging requires primary key and SQL Server 2012 (or above)

Open rwhirn opened this issue 4 years ago • 1 comments

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): SQL Server 2014 (Express)

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 174

  3. 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.

rwhirn avatar Aug 03 '21 21:08 rwhirn

Thanks @rwhirn we're checking it

huyphams avatar Aug 04 '21 08:08 huyphams