Hi Tim,

Just a suggestion for ElevateDB Manager next time you make a new release.

Would it be possible when a statement window is open to select an some text, right click and have an option 'Run Selected' which would just run the selected text ?

This would be very very handy when developing, as it means I could have many different statements in the same window, select one and just run that statement, as oppose to commenting out statements.

I like to have alot of useful SQL statements in the same window when developing and I'm often running different statements, testing etc... So this would be a great addition and time saver.

Thanks,

Phil.

I take that back Tim...

I just realised I can acheive this already using '!' as a terminating character between the statements and left clicking / right clicking on the gutter.

Just wasn't aware of this feature, awesome, good job!

Phil.

>>Just wasn't aware of this feature, awesome, good job!

EDBManager is fully of annoyingly useful features ... annoying because they tend to be a bit hidden away ... once you know how to use them it is great.

Thanks for letting me know about this one, it is new to me too!

... by the way my favourite EDBMgr hidden feature is the ability to create CREATE TABLE SQL by dragging a table's icon from the Tree-view into an empty SQL Statement ... try it if you haven't already.

Adam Brett wrote:

> EDBManager is fully of annoyingly useful features ... annoying
> because they tend to be a bit hidden away ... once you know how to
> use them it is great.
>
....
> .. by the way my favourite EDBMgr hidden feature is the ability to
> create CREATE TABLE SQL by dragging a table's icon from the Tree-view
> into an empty SQL Statement ... try it if you haven't already.

It is much worse that that!  
I knew about the drag'n'drop to get the create table .. but I did not
remember it prompted for the data INSERTs as well, so I recently used a
full reverse engineer and huge edits to get at the INSERTs.   <sigh>  

I constantantly stumble on the new functions.

I think right now my favorite thing I'd love to see is to round-trip Delphi statements with SQL over and back.   Right now, I dump the SQL to a text file and then paste it.   

Lance



Philip Read wrote:

I take that back Tim...

I just realised I can acheive this already using '!' as a terminating character between the statements and left clicking / right clicking on the gutter.

Just wasn't aware of this feature, awesome, good job!

Phil.