#57 F10 execute the wrong line

V1.21RC3
closed-accepted
nobody
None
5
2011-10-29
2011-10-29
MOKHTARI Alain
No

When SQL commands are not separate by a blank line, F10 always execute the last command (last line).
For example :
SELECT * FROM acts; (<= cursor here)
SELECT * FROM acts_root; (<= or cursor here)
SELECT * FROM acts_root where SESSION_ID=11; (<= command executed !)

When SQL commands are separate by a blank line it's OK.

Discussion

  • randolf_geist
    randolf_geist
    2011-10-29

    This is a side-effect of the new default mode of SQLTools++ by searching
    for the next empty or whitespace only line above the current line.

    If you don't like that you have the option to control that behaviour by
    going to "Tools->Settings->PlusPlus Settings" and unchecking "Empty line delimits statement" and/or "Whitespace line delimits statement"

     
  • randolf_geist
    randolf_geist
    2011-10-29

    • status: open --> closed-accepted