#1057 remember table column sizing in sticky mode

3.4.0
closed
Core (461)
5
2013-01-08
2012-11-01
ding
No

When you right click a sql tab and set it as sticky, the property "Keep SQL result table layout on rerun SQL" is ignored when you use the top run icon but works when you use the bottom (run again) icon.

(If you click Ctrl Enter or use the top icon, you lose the column sizes.)

Possibily related, some others have talked about having a shortcut that runs the "run again" running icon instead of the run icon. A 3rd party patch is available for an old version which achioeves this (works on v3..2.1) but it does not work on 3.3. or 3.4.
http://muzso.hu/2011/06/04/patch-for-squirrel-sql-client-v3.2.1-adds-keyboard-shortcut-for-sql-query-rerun-re-execut

Can we either get a hotkey for the bottom (run again) icon OR make the top icon not ignore the sticky setting (so it does not resize the columns)? (or both)

Discussion

  • Johnathan James

    Johnathan James - 2013-01-08

    Patch attached to resolve this Bug/Feature Request..

    I actually think the "ignoring" that happens when you click the "top run icon" is how it should be. The run icon at the bottom has many less assumptions to make in order to respect the "Keep SQL result table layout on rerun SQL" property. For instance, it already knows the SQL to be run. By comparison, the button at the top needs to parse the SQL Text Field in order to find its SQL. And this SQL may not be the same as the SQL in the current tab. So anyway, long story short, I did not address the first issue.

    I did, however, re-work the patch found at the website mentioned, so that the current tab's SQL can be re-run with the keypress, CTRL-SHIFT-R.

     
  • Gerd Wagner

    Gerd Wagner - 2013-01-08

    Johnathan's re-worked patch is applied to our SVN repository and will be available in future snapshots and versions.

    I think that Johnathan's analysis is correct. Nonetheless there may be an easy to understand and logically clean requirement concerning the problem. But any way this should be rather a feature request than a bug.

    So this bug is closed.

     
  • Gerd Wagner

    Gerd Wagner - 2013-01-08
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks