Command Execution vs. F8

[townsendEbmud]

This enhancement is for the command window. There are times when I have something in the editor and have switched back to the command prompt. I type in a quick SQL at the prompt then hit F8. Oops. I just executed the contents of the editor and not the command I just typed in. Hopefully what I had in the editor was benign!

If we have something entered at the prompt AND something in the editor when we hit F8 (or the icons), could we get a prompt that lets us choose which we want to execute? Or even better from my perspective (but maybe not everyone else's), if there is something typed at the prompt when I hit F8, execute that and not the editor contents.

Thanks.

 

[Claus Pedersen]

I agree on this request.

Pressing F8 to execute everything is becomming more and more of an unconditional reflex (I even sometimes press F8 and F10 in M$Word , without getting the results I expect), so this enhancement would be quite nice.

 

[ed10k]

Anyway must exist the possibility of execute the contents of the editor without change to editor window.

Perhaps in that way: if you typed nothing into command prompt then execute the content of editor window.
Otherwise execute the statement typed into the command prompt.

 

[kcrider]

Originally posted by townsendEbmud:
Oops. I just executed the contents of the editor and not the command I just typed in. Hopefully what I had in the editor was benign!

We've probably all done this...

I've gotten in the habit of placing a single dash, "-" at the top of the SQL window if I am going to have multiple statements in the window at once. This automatically fails with an error if I hit F8 with nothing selected.

I like the idea that if there are multiple SQL statements in the window, and nothing is selected, then I get prompted...

 

[Marco Kalter]

I have added this to the list of enhancement requests.