SQL Complete doesn't know what current statement is sometimes

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Thenrich
Posts: 105
Joined: Sun 21 Dec 2014 19:47

SQL Complete doesn't know what current statement is sometimes

Post by Thenrich » Thu 07 Mar 2019 20:21

Using 6.0.101. I have alt-enter mapped to SQLComplete.ExecuteCurrentStatement.

I have a SQL statement with a definition of multiple CTEs separated by commas. For testing purposes, I enter in between a SQL statement like ;select * from customer;. Note the two semi columns before and after the statement. If I hit alt-Enter, I get syntax errors. But if I highlight the line, I can execute it.

This means SQL Complete is parsing code that comes before or after the statement. I thought semicolumns define what a statement is and SQL Complete should not be looking outside of these statement delimiters.

alexa

Re: SQL Complete doesn't know what current statement is sometimes

Post by alexa » Tue 12 Mar 2019 14:28

Could you please provide us the script and describe the steps to reproduce the issue in detail? A video demonstrating the issue would be also of help.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Post Reply