ssms-executor icon indicating copy to clipboard operation
ssms-executor copied to clipboard

The extension fails when there is an error elsewhere on the page.

Open manngo opened this issue 3 years ago • 1 comments

I have no idea what’s happening on the inside, but the extension doesn’t appear to be limited to the current statement. For example, when I have something like the following:

select;
select * from books;
select * from customers;

and try to run just the last statement (ctrl-shift-E) the error on the first line stops the last line from running.

Is this something that can be fixed?

manngo avatar Sep 24 '22 00:09 manngo

Hi @manngo,

the extension first tries to validate/parse the whole query, and then extracts the separate sql statements. If there is an syntax error, it fails to parse the statements and the execution is stopped.

I might look into this, as it annoys me too.

devvcat avatar Sep 25 '22 12:09 devvcat