Page 1 of 1

Can't execute current statement when certain statement precedes it

Posted: Fri 08 Nov 2019 00:48
by Thenrich
I have code like this:

alter procedure x
as
begin
...
end

; select * from table;

When the cursor is inside the select statement and I execute current statement it doesn't get executed. When I remove the alter statement, it gets executed. My understanding is that when I have a semi column before my statement, it isolates my statement from prior statements. It works if the alter is another select for example.

Why doesn't it work with certain previous statements like an alter procedure?

Using SQL Complete 6.2.37.

Re: Can't execute current statement when certain statement precedes it

Posted: Mon 11 Nov 2019 10:39
by alexa
We were able to reproduce this issue and will fix it in one of the next product builds.

We will notify you once it's available for downloading.

Re: Can't execute current statement when certain statement precedes it

Posted: Mon 11 Nov 2019 17:57
by Thenrich
I would like to add also that if my statement is enclosed between two semicolons, it should be isolated and I should be able to execute it regardless if the SQL that comes before or after it has syntax errors. It should not care.