Invalid usage of the option NEXT in the FETCH statement

[jbrooksuk]

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

   Microsoft SQL Server 2008

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

   Build 87

3. The steps to reproduce this issue:

   Try to view table data on a Microsoft SQL Server 2008 database.

[huyphams]

It's duplicated with: #225

[huyphams]

Hi @jbrooksuk can you help me test this statement in SQL Query:
SELECT * FROM <table> ORDER BY 1 BETWEEN 0 AND 5;

I didn't have any MS SQL Server 2008 for testing.

[jbrooksuk]

Incorrect syntax near the keyword 'BETWEEN'.

[huyphams]

Ok, I will install a Virtual machine and install MS SQL 2008 😄

[jbrooksuk]

Thanks @huyphams!

I'll be purchasing a license soon enough :)

[huyphams]

Hi @jbrooksuk it's fixed in this build: https://www.dropbox.com/s/3orqil53ktk8yzk/TablePlus.zip?dl=0
Can you give it a try and let me know if it works for you 😄

[jbrooksuk]

@huyphams this is working perfectly. Thanks 🚀