Quality Of Life enhancements

[pawelsalawa]

• Database list - Ctrl+drag table/view onto the SQL Editor -> generate SELECT.
• Database list - Ctrl+drag selected columns onto the SQL Editor -> generate SELECT with these columns.
• Database list - Ctrl+Shift+drag table onto the SQL Editor -> generate UPDATE.
• Database list - Ctrl+Shift+drag selected columns onto the SQL Editor -> generate UPDATE with these columns.
• Database list - Drag selected columns (without meta keys) onto the SQL Editor -> paste column names, comma-separated.
• Grid View - F4 to edit contents in a MultiEditor dialog - this will replace Alt+Enter
• SQL Editor - F3 on an object to open that object (Table Window, View Window, Index Dialog, Trigger Dialog)
• Expanding asterisk operator in SELECT to actual columns using a shortcut, or with Code Assistant when triggered on the asterisk.
• Configuration Dialog should remember tab on which it was closed and next time reopen on that tab.
• Add suitable items from this list to TOD ("Tip of the day" message in status window #3283)

[JrgMyr]

Very helpful, indeed. Thank you.

Is there a way to expand the asterisk in queries into the series of field names? Example: one wants to write a query with several fields. Writing "select * from xyz" then expanding the asterisk into the actual columns, then erasing the unwanted ones could also reduce typing.

[pawelsalawa]

Awsome! Adding it to the list.

[JrgMyr]

It would probably suffice if one could drag and drop column names (ideally multiple at one time) from the database pane on the left into queries. Right now table names can be moved this way but not column names.

[pawelsalawa]

Another one good! Adding.

[JrgMyr]

In the SQL Editor, [Ctrl-S] needs to be pressed twice to save, whereas works immediately.
For me it's the same way on different Linux and MS-Windows machines.
Is it like that for everybody?

[pawelsalawa]

What needs to be pressed twice to save what and where?

[JrgMyr]

When I apply a change to a query, then the grey button "commit changes" becomes green and the grey button "rollback changes" becomes red. This is how it is supposed to be. From there it is not possible to execute the query directly. Obvious.

Then it needs [Ctrl-S] twice to get them back to grey. I believe that the actual "save" is effective after the first [Ctrl-S] because I can already execute the query with [F9]. Nevertheless, it takes a second [Ctrl-S] before the green and red highlighting disappears. Hope this helps.

[pawelsalawa]

I assume you've changed the default Ctrl+Return hotkey to Ctrl+S. This way it behaves as you described, because Ctrl+S is now assigned to 2 different actions - 1 is to commit data changes, 2 is to save SQL query to a file. Qt will trigger these 2 actions alternately for each hotkey hit.