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

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

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

Roy,

> I suspect because that's actually used in scripts.

Probably.
I tried "#" and that doesn't work either, while "\" works.

Uli

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