Translate external SQL

Also in the version 2.0 the essentially new opportunity of transformation SQL in a graphic kind Visual SQL-Designer is realized. For this purpose it is necessary on the Main form click on button "SQL". Opened the window will contain buttons "Execute" and "Translate" (Fig.1). In working area it is possible to enter SQL lines. The ambassador pressing of the button "Translate" the entered SQL string will be transferred in a graphic kind. Let's notice, that by the first pressing on the screen the form of dialogue, for definition of a line of connection with a source of the data will appear.

Fig.1

There are some distinctive features of the re-engineering process. If the joins between the tables are realized through conditions (In part of the WHERE), at converting they will be included in the filter (WHERE). It is impossible to use hierarchical SQL search of a kind " Select... From (Select …)... " .All sources of the data should be in one database (we remind direct search can include the data from different sources of the data). We hope that these restrictions will not render essential influence on a rating of new opportunities of this product.