Starting in version 4.2.0 (build 917) known as 4.2EA you can define the query for a view without using the Query Builder. You can simply type or copy/paste the SQL query wanted to the new Query box in a new Query tab located in the View Properties:

ea2_6

You can test the query by pressing the Test Query button. If I had pressed that button I had noticed that I made a typo on table name (load vs. loan)  😀 This button is very useful…

Of course the Query Builder is also available if you rather use that. But when and why would I like to use this new functionality? I know that using this functionality there will be no lost of formatting, no problems with hints, no problems with the comments inside the query etc. In short no editing that is not done by me  🙂

 

 

Advertisements