Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
EDBManager: Run only query which is selected |
Mon, Apr 15 2019 9:40 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | 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 |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |