Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread EDBManager: Run only query which is selected
Mon, Apr 15 2019 9:40 AMPermanent Link

Yusuf Zorlu

MicrotronX

Is it possible that we get a functionality so i.e. i have these texts in query window:

select * from positionen;
select * from positionen where nl=1;
select * from positionen where nl=8;

when i click into line 1 it should only execute that line (till ; char) or also possible that i select / mark the line 2 and click to Execute and it runs only the selected query.

Would enable us to have one sql file with more than one query, select line and execute it ... for debugging ...

Thanks,

Yusuf Zorlu
MicrotronX
Mon, Apr 15 2019 10:31 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Yusuf


What I do is comment out one or more lines. Not as easy as simply clicking into a line but when I have multi-line queries it shows what's been commented out so its easy to spot

Roy Lambert
Wed, Apr 17 2019 2:35 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Yusuf,

<< Is it possible that we get a functionality so i.e. i have these texts in query window:

select * from positionen;
select * from positionen where nl=1;
select * from positionen where nl=8;

when i click into line 1 it should only execute that line (till ; char) or also possible that i select / mark the line 2 and click to Execute and it runs only the selected query. >>

Is this a script, or just a normal query window ?  With a normal query window, the default way to do this is to specify the queries like this:

select * from positionen!
select * from positionen where nl=1!
select * from positionen where nl=8!

and then click in the left-hand gutter to select which query you want to execute.  By default, *all* queries will get executed if you haven't specifically selected one.

As you can see, the default statement terminator is the ! character, and this is because you could be executing DDL statements that contain statements with semicolons, and that can mess up the parsing that is used for determining where a statement begins and ends.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Apr 18 2019 2:28 AMPermanent Link

Yusuf Zorlu

MicrotronX

Tim Young [Elevate Software] wrote:

<< Is this a script, or just a normal query window ?  

It is a normal query windows


<< With a normal query window, the default way to do this is to specify the queries like this:
select * from positionen!
select * from positionen where nl=1!
select * from positionen where nl=8!


Wow great, this was what i was searching for! Thanks!

Yusuf Zorlu
MicrotronX
Image