Menu

#593 ; not working as separator for single query, taking multiple query

SQuirreL
open
nobody
separator (1)
medium
2020-06-20
2020-06-20
No

Hello

Earlier i was using SQL Developer and recently i downloaded SQuirreL SQL client. While working i noticeds some different/issue.

i had query written as below in SQuirrel and cursor in 1st query. I executed them using Ctrl+Enter.
I was expecting only 1st query to execute like SQL devleoper but it executed both the queries.

Update table1 set col1=value1;
update table2 set col1=value2;

on finding more detail realized that even though ; is used as a seperator, Squirrel actually takes empty line as separator else takes all the query for single execution and query box highlight also show them as one execution.

Is there any way to change this behavor to make it similar to SQL developer where single query is executed with ctrl+Enter with ; as separator. for multiple query i can select many queries/highlight and then execute.

Thanks
Dinesh

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.