Start a new topic

Generate Where Clause Based On Selection In Grid

[This topic is migrated from our old forums. The original author name has been removed]

It would be nice if a where clause could be generated based on the selection in the result set grid.

One could select any (not necessarily neighbouring) cells in one or multiple rows of the result set grid and then generate a where clause that restricts the columns to these values (ANDed or ORed between different columns, IN-listed for different values across rows) by choosing an option in the context menu and/or keyboard shortcut.

That would be very helpful.

Cheers,
Chris

[This reply is migrated from our old forums.]

Re: Generate Where Clause Based On Selection In Grid
Chris, The quoting problem is fixed in 6.0.7. http://www.minq.se/products/dbvis/download.html Best Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Generate Where Clause Based On Selection In Grid
Thank you very much! I haven't seen this feature yet... Sorry.

It seems to be available only in the Object View / Data Tab. A similar functionality for the SQL Commander output grid would be great (adding the where clause to the statement in the editor (or to the clipboard) instead of setting a filter).

There seems to be a small issue with the filter generation. Varchar column values that contain a dash (-) are not being quoted.

Also it would be nice if it was possible to select different columns in different rows.

Cheers,
Chris
[This reply is migrated from our old forums.]

Re: Generate Where Clause Based On Selection In Grid
Chris, In the Data tab you may select the desired cells and then choose the [b]Filter[/b] right click menu choice. A number of operators are displayed in the sub menu. This will generate a Filter (where clause) and display it in the Filter dialog. Is this what you are looking for but instead of generating a filter it should pass the generated SQL (select * from xxx where ) to the SQL Commander? Regards Roger