Menu

#1991 Ctrl-Shift-F9 broken in latest versions

Invalid
nobody
None
Defect
2010-06-06
2010-06-05
Anonymous
No

Originally created by: technoma...@googlemail.com

What exact steps will reproduce the problem?
1. Have 2+ separate queries in an sql window
2. Put your cursor on the end of a random query
3. Press Ctr-ShiftF9

What was the expected output?
This used to execute the query on which your cursor is

What happened instead?
Pops with mysql syntax error; heidi seems to try to execute all queries in
the sql window

Suggested fix (optional)?
I know of Ctrl-F9 which executes the "selected" text but Ctrl-Shift-F9 is a
feature that worked for years and does not work anymore.

Version used?
HeidiSQL revision: latest daily
MySQL Server version: any
Operating system: Win any

Discussion

  • Anonymous

    Anonymous - 2010-06-05

    Originally posted by: a...@anse.de

    Works for me. Look at the screenshot and please compare the cursor position to the
    one you meant. And please ensure you didn't customize your shortcut for "Run current
    query" by right click into query memo and having a look at the popup menu item.

    Status: NeedInfo

     
  • Anonymous

    Anonymous - 2010-06-05

    Originally posted by: technoma...@googlemail.com

    Try as above but *without* a semicolon on first row, i.e.:
    select 1
    select 2 (put your cursor here and press Ctrl-Shift-F9)

    This worked for years and was very useful; ppl like to type queries once after the
    other and execute them separately in the same window; it broke recently

     
  • Anonymous

    Anonymous - 2010-06-05

    Originally posted by: a...@anse.de

    Ah I see - you expected the old behaviour "Run current line" which was requested to
    be changed to "Run current query". See issue #821 for a discussion about that change.

    To fix that, just place a delimiter (semicolon) after "SELECT 1". The good thing is
    that queries can span more than one line, so the following now also runs:
    SELECT 1, 2,
      3,<CURSOR HERE> 4;
    SELECT 5

    Status: Invalid

     

    Related

    Tickets: #821

  • Anonymous

    Anonymous - 2010-06-06

    Originally posted by: technoma...@googlemail.com

    Ok the key changed behaviour. As a humble advice, try to use a *new* key for new
    functionality asked and leave previous behaviour untouched because it is *used* ;
    e.g. many query files have been saved *without* the semicolon separating so all this
    has to be rewritten. This is like someone asking to change save key (Ctrl-S) to now
    behanve as "Send Doc as Email" in an Office application - you would not be that happy
    with that. Can you at least give us a key and menu item with the old "Run Current
    Line" bahviour?

     
  • Anonymous

    Anonymous - 2010-06-06

    Originally posted by: a...@anse.de

    No, sorry. If you honestly want that you should dive into the discussion in issue #821.

     

    Related

    Tickets: #821

MongoDB Logo MongoDB