Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Feature Requests

Thread: Quick execute feature for Query Builder


Permlink Replies: 4 - Pages: 1 - Last Post: Apr 11, 2008 3:02 PM Last Post By: Ed
Ed

Posts: 96
Registered: 03/31/08
Quick execute feature for Query Builder
Posted: Mar 31, 2008 9:58 PM
   thread.click_reply Reply
I am evaluating DBV with a view to migrating a community of non-technical users over to using it for generating ad-hoc database queries. Their generation of new queries is intermittent (say every other day at the most frequent) so ease of use is paramount.

One thing that gives me pause is the need to copy SQL from the Query Builder to the SQL Editor in order to execute it. What I'd like to see is the easiest way of viewing query results from a QB generated query. Would it be possible to have a couple of extra buttons in Query Builder?

A do it it now button which copied to SQL Editor and executed the query

A quick do it button which maybe had a 'limit 10' on the query to check what the results looked like.

Ideally this could be done without leaving the query builder pane but that might be asking too much.

Ed
Hans Bergsten


Posts: 1,539
Registered: 10/11/06
Re: Quick execute feature for Query Builder
Posted: Apr 2, 2008 8:34 PM    global.in_response_to.tooltip in response to: Ed
   thread.click_reply Reply
Hi Ed,

Adding a "do it now" button in the Query Builder that copies the SQL to the SQL Editor and executes it, showing the result (and the SQL) in the SQL Editor would be fairly easy to do. To limit the number of rows in the result, you can enter a value in the Max Rows field. Would that satisfy your needs?

Executing the query and showing the result without switching the GUI to the SQL Editor would require a lot more implementation effort.

Best Regards,
Hans
Ed

Posts: 96
Registered: 03/31/08
Re: Quick execute feature for Query Builder
Posted: Apr 2, 2008 11:06 PM    global.in_response_to.tooltip in response to: Hans Bergsten
   thread.click_reply Reply
Yes, a 'do it now' button, would meet the bulk of my needs, must admit I hadn't noticed the max rows field.

Thanks for listening,

Ed
Hans Bergsten


Posts: 1,539
Registered: 10/11/06
Re: Quick execute feature for Query Builder
Posted: Apr 10, 2008 4:24 AM    global.in_response_to.tooltip in response to: Ed
   thread.click_reply Reply
Hi Ed,

The "do it now" button will be included in the next Early Access (EA) version, scheduled for release tomorrow, and then in the next feature release. Please try out the EA when it becomes available and let us know what you think.

Best Regards,
Hans
Ed

Posts: 96
Registered: 03/31/08
Re: Quick execute feature for Query Builder
Posted: Apr 11, 2008 3:02 PM    global.in_response_to.tooltip in response to: Hans Bergsten
   thread.click_reply Reply
Have tried this out in the EA version, seems to work OK and is a worthwhile improvement IMHO.

Thanks a lot.

Ed

Point your RSS reader here for a feed of the latest messages in all forums