Page 1 of 1

Ctrl-E doesn't execute SQL?

Posted: Sun 14 Jun 2015 13:42
by Rufus
So I'm trying to trial this software but ctrl-e doesn't execute the SQL. I've used ctrl-e to execute SQL since SQL Server 6 now it goes into some kind of antique WordStar macro-mode?

How do I fix this lame behavior?

Re: Ctrl-E doesn't execute SQL?

Posted: Mon 15 Jun 2015 08:49
by alexa
Starting from SSMS2012, you can redefine the shortcut for the 'SQLComplete10.Common_ExecuteCurrentStatement' command in the 'Environment -> Keyboard' section of the 'Options' window that can be invoked by selecting 'Tools -> Options' from the main menu.

Re: Ctrl-E doesn't execute SQL?

Posted: Mon 15 Jun 2015 12:48
by Rufus
Let me clarify. ctrl-e is working as expected in SSMS 2012 and 2014 for me. It's the trial for dbForge that has the WordStar behavior for me.

I don't see any commands called 'SQLComplete10.Common_ExecuteCurrentStatement' in Environment > Keyboard in dbForge.

I do have the SQL Server Management Studio mapping scheme applied, but when I press Ctrl-E in the box to assign it, I see several mapping that start with that keypress followed by a 2nd keypress. Query Builder has it defined to Sql.Execute, but that's evidently correct.

Re: Ctrl-E doesn't execute SQL?

Posted: Mon 15 Jun 2015 13:36
by alexa
The mentioned instructions were for another our product dbForge SQL Complete https://www.devart.com/dbforge/sql/sqlc ... nload.html

In case you are referring to dbForge Studio for SQL Server, please perform the following:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Keyboard' branch.
3. Type 'Sql.ExecuteCurrent' in the 'Show Commands Containing' field.
4. Select the found 'Sql.ExecuteCurrent' command in the list below.
5. In the 'Use new shortcut in' field, select 'Text Editor'.
6. Set the focus in the 'Press shortcut keys' field and press the required key combination.
7. Click the 'Assign' button.
8. Click 'OK'.