Thanks to the developers of this plugin, seems to me so far to be very handy. Two things I'd like to know are:
1. Can SQL Explorer strip comments from the editor before running the statement?
2. Can I set my own keyboard shortcut to run either the entire script in the editor, or the selection? CTRL+Enter is the default for these.
I'm using version 3.5.0.RC8 on Win XP.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
SQLExploerer parses the script to determine singel statements and send each to the SQL server. Comments are not stripped. Normaly this is no problem. Why do you want to have comments stripped?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
3.5.1 SR1 is released with the new option to strip comments before executing.
Update your installation.
Go to the SQL Explorer preference page and chekc the option to strip comments.
Run your queries.
Starting with 3.5.1 you can change your key mapping for the SQL execution in the Eclipse Key Map Editor (Preferences / General / Keys). Type 'exec' in the filter field and you will see the two 'Excute SQL' commands with there mappings.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks to the developers of this plugin, seems to me so far to be very handy. Two things I'd like to know are:
1. Can SQL Explorer strip comments from the editor before running the statement?
2. Can I set my own keyboard shortcut to run either the entire script in the editor, or the selection? CTRL+Enter is the default for these.
I'm using version 3.5.0.RC8 on Win XP.
SQLExploerer parses the script to determine singel statements and send each to the SQL server. Comments are not stripped. Normaly this is no problem. Why do you want to have comments stripped?
I'm currently querying a Microsoft Access database, and it doesn't like comments.
Ok, I will add it as a configurable preference with the next release.
3.5.1 SR1 is released with the new option to strip comments before executing.
Update your installation.
Go to the SQL Explorer preference page and chekc the option to strip comments.
Run your queries.
Starting with 3.5.1 you can change your key mapping for the SQL execution in the Eclipse Key Map Editor (Preferences / General / Keys). Type 'exec' in the filter field and you will see the two 'Excute SQL' commands with there mappings.
Awesome! This sort of rapid response is a bit like flying first class… I'll try not to get used to it.
Thanks very much for the update :)
Ben
:-)