Is it possible to execute only the highlighted query text in the query window?

Avatar
CrashTang
  • updated
  • Completed
When writing a free-form query (not using Visual Query Builder), how can I get FlySpeed to execute only the highlighted query text. It attempts to execute every statement in the query sheet, when in fact the sheet may contain dozens of individual queries.  Perhaps highlight the select statement, then right-click to get an option to execute only the highlighted text?
Replies 7
Avatar
0
Anonymous
This is not possible in the same window, but you can click the "Create New Query from Selected Text" button on the query builder toolbar and then execute the selected query in the new window.

By the way, clicking the Execute button with the Ctrl key pressed will allow to execute a multi-query script.
Avatar
0
Marcus Breig
I also would like this feature. Often I have a list of sql-update/insert-statements. Under Access it is not possible to execute them all with a single F5 (execute). So it would help me if I could mark these statements one after an other and execute them.
Avatar
0
Anonymous
We will start working on this feature right after releasing the version 3.1 (this will happen shortly). 
Avatar
0
Marcus Breig
Thank you for this information. This feature would be fine!
Avatar
0
CrashTang
That is good news, the feature would be appreciated! Thank you.
Avatar
0
André Müller

I guess this is still pending, or not? It would be very much appreciated.

Avatar
0
Anonymous

Sorry for keeping you waiting in the implementation of such an easy feature. We are going to implement this option in a month.


Customer support portal powered by UserEcho