Query by example text in version 7

[Tim Ashepkov]

I switched from version 6 to version 7 recently, and noticed that query by example does not anymore modify the actual text of the query in the SQL Window.

For example, in SQL Window I press query by example button (binoculars) and under column X I type a condition "> 10".
Then I execute query.
The query itself works fine: it displays only rows, where column X > 10.
However, the actual text of the query in the SQL window does not change. In version 6, it used to change to "SELECT * FROM Y WHERE X > 10" to reflect my changes.

Was that functionality changed in version 7? If it is still there, how can I turn it back on?

Thank you.

 

[Marco Kalter]

The actual SQL text is indeed no longer visible, as a result of the fact that you can now run scripts with multiple statements. You are not the first to ask about this though, so maybe we can get this back somehow.

 

[Tim Ashepkov]

That would be great.

 

[davemans]

As a workaround, you could do Ctrl-E and get it back from the Recall buffer.

 

[DUTRA GmbH]

I have the same problem and it would be more than nice to see the "complete" SQL statement.

I can't work with this version, because I often show the same table in different windows (now tabs) with different selections. If I want to switch between these windows I use the Window List (mouse over the bar) to choose the one I want. Without this information it is much heavier to get the right window.

Please make it possible to select the new and the "old" SQL Window.

Thank you in advance.

 

[Mark Heckman]

My sentiments exactly. I use the QBE feature regularly to generate statements that I then incorporate into my code.

Thanks for a great product that makes my job easier!

 

[Max_Revan]

Having this functionality working in the previous version, i think it would be really well-advised to make it work again...

 

[Marco Kalter]

We have done so for the upcoming 7.0.1 patch release. If the SQL script consists of just one statement, it will be replaced by the QBE query.