Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 5 of 5 total |
EDBMgr Execute current SQL statement (F9) or all SQL statements (Ctrl-F9) |
Sun, Aug 26 2012 2:01 PM | Permanent Link |
Barry | A New.Sql window should allow us to have more than 1 SQL statement separated by ";" in the SQL editor.
When the F9 is pressed the i-beam "|" caret should tell EDBMgr which SQL statement to execute. It will then execute the SQL statement between the ";". The reason I'd like to see this is I can work in a single SQL tab and have a history of SQL statements that I've been working on for the past hour without opening more tabs. Opening more tabs obscures prior SQL statements and muddles up the screen. I never know which tab has the SQL statement I'm looking for. Putting related SQL statements under one tab will organize the SQL statements much better. It is a lot like reading several sentences (SQL statements) one after the other, instead of jumping around tabs looking for the next sentence (SQL statement). By having the caret determine which SQL statement to execute, I can easily execute any one of the SQL statements that is in the window. I know I can use "/*" and "*/" to add comment blocks around prior SQL statements, but this is more work than necessary for the user. If there are multiple SQL statements in the SQL editor, pressing Ctrl-F9 will execute all of them from start to finish. This is great when playing around with writing a sequence of SQL statements like dropping a table, creating a table from scratch, executing updates etc.. I can execute any one of them with F9 and when I think it is working properly, I can use Ctrl-F9 to execute all of the SQL statements in the SQL editor. Once I have this working, I can then copy and paste this SQL into my Delphi program knowing the sequence has been thoroughly tested. In my MySQL projects, I can save the SQL in a memo column of a table and have Delphi retrieve the memo and execute it in a batch (I parsed out the SQL statements one by one). This is an alternative to using Scripts which is a language until itself. Sometimes I'd rather use nothing but SQL instead of a scripting language. Having all of the SQL statements in a single EDBMgr tab will help to facilitate this. Barry |
Sun, Aug 26 2012 4:22 PM | Permanent Link |
Uli Becker | Barry,
> A New.Sql window should allow us to have more than 1 SQL statement separated by ";" in the SQL editor. > When the F9 is pressed the i-beam "|" caret should tell EDBMgr which SQL statement to execute. It will then execute the SQL statement between the ";". There is something similar available in EDBManager: You can write several statements in one window and separate them by using "!" (default). Then just klick into the gutter on the left of the statement that you want to execute and press F9. Only the selected statement will be executed. P.S. I just tried to replace the "statement termination character" in the preferences to ";". That doesn't seem to be possible We have to ask Tim, why not. Uli |
Mon, Aug 27 2012 3:44 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Uli
>P.S. I just tried to replace the "statement termination character" in >the preferences to ";". That doesn't seem to be possible We have to ask >Tim, why not. I suspect because that's actually used in scripts. Roy Lambert |
Mon, Aug 27 2012 4:04 AM | Permanent Link |
Uli Becker | Roy,
> I suspect because that's actually used in scripts. Probably. I tried "#" and that doesn't work either, while "\" works. Uli |
Wed, Sep 5 2012 7:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Uli,
<< P.S. I just tried to replace the "statement termination character" in the preferences to ";". That doesn't seem to be possible We have to ask Tim, why not. >> It's an issue with the statement terminator being assigned properly internally in the editor. It's now fixed. Thanks, Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |