Execute command is missing

Hi,

I don't understand why sometimes the execute button disappears from the window, I can still run sql queries using Ctrl+Enter but the button itself is gone. Also, sometimes I can't run commands even with Ctrl+Enter. Could someone please explain this behavior?

Thanks

12 comments
Comment actions Permalink

Hello Leandro,

Execute button is mapped to Ctrl+Enter "Execute current multi line statement" action. So, if the cursor is inside such a statement the action is available. Please check also this answer https://devnet.jetbrains.com/message/5539955#5539955

0
Comment actions Permalink

Hi Andrey,

I know about the shortcut, I don't understand why the button disappears and intellij refuses to run my queries sometimes.

Thanks

0
Comment actions Permalink

I don't understand why the button disappears and intellij refuses to run my queries sometimes.

The action is not available when the context is not appropriate for this: i.e the cursor is not inside the statemen, surrent statemen (inside cursor) is invalid. You can also see a light background selection of the statement when the context is right.

I can still run sql queries using Ctrl+Enter but the button itself is gone.

Could you please provide examples of this behavior? What DB do you use? Screenshots are very welcome.

0
Comment actions Permalink

I'm attaching two images showing two tabs, one of them doesn't have "Execute" action, the other one does. Also, I cannot toggle auto-commit mode in the first one.
Why is that?



Attachment(s):
2.gif
1.gif
0
Comment actions Permalink

Unfortunately attached screensots do not let updarstand the issue (where the cursor is located at that moment? when is your sql console content?). Can you provide this information as well please?

0
Comment actions Permalink

The cursor is located in the sql editor.

0
Comment actions Permalink

Yes, I understand that it is located in sql console editor, but the exact location is important. Please attach screenshots showing complete sql console tool window so that sql queries and cursor were visible for two different cases.

0
Comment actions Permalink

I think Leandro Aparecido misunderstands the issue here. 

The button disappears if the syntax of the SQL commands in the console window are invalid. Go fix the queries and the button will appear.

I'd like to add that this behavior is not intuitive in my opinion (I had to come hunting for this post to figure it out). What might be better is if the button was just disabled, not missing, and there was an emphasized message somewhere in the UI that explained that the queries are not executable because of syntax errors.

0
Comment actions Permalink

Hello Matthew,

Thank you for feedback. I'll let the developer known.

0
Comment actions Permalink

I'm running the latest EAP and my SQL execute buttons have completely disappeared for all my stored functions. The buttons are still there for the SQL editor/scratchpad. I'd sure like to know how to get them back...

1
Comment actions Permalink

Same here. Am running the IntelliJ IDEA 2016.3 EAP (Build #IU-163.7743.17, built on November 8, 2016) and the run and refresh buttons are gone from the stored procedure editor.  For one of my databases, I could still see them:


But when I deleted that datasource and recreated, they were gone. So was the "DROP PROCEDURE" statement.

 

0
Comment actions Permalink

I'm told the missing Run and Refresh buttons are a "feature". Please vote to remove this so called feature and get them back:

https://youtrack.jetbrains.com/issue/DBE-3473

0

Please sign in to leave a comment.