Multiple Statements undesired behaviour

[Gustavo]

Hi,

Before Multiple Statements functionality, all I had to do to run a query was: place the cursor somewhere in the statement and press F8 (Execute). Now, when I press F8, SQL Windows always try to run everything, and I have to blockmark a single statement, if that's all I want.
Multiple Statements is great, but there should be different commands to:
1. Run current statement;
2. Run from this statement and on;
3. Run everything (this should be restrictable to selected statements, if any).

Regards,
Gustavo

 

[Gustavo]

Hi,

I'd like to add that errors happen only when there is something after ';'.
For instance, I run:
select * from emp where 1=1;
Then I decide to query the whole table, and I add a ';' in the middle of the line, like this:
select * from emp; where 1=1;
I place the cursor in the 1st portion (the valid statement) and I get an error:
ORA-00911: invalid character
And a red underscore is shown on the 1st ';'.

Regards,
Gustavo

 

[Marco Kalter]

Multiple Statements is great, but there should be different commands to:
1. Run current statement;
2. Run from this statement and on;
3. Run everything (this should be restrictable to selected statements, if any).

If you select a number of statements, these will be executed. You can therefore perform all scenarios mentioned above.

 

[Marco van der Linden]

Still, it would be nice if, with autoselect on, you could use a shortcut to execute all statements without having to ctl-A first. Like F8 => execute statement, ctl-F8 => execute window.

 

[mike]

I like your idea.

A short macro that does CTL+A, F8 would help some. Assign it to the menu and create a hot-key of CTL+F8 for the menu item.

Mike