Please enable JavaScript to view this site.

Altova MapForce 2020 Professional Edition

SQL statements can be generated automatically from the Database Browser, loaded from scripts, or entered manually.

 

 

To generate SQL SELECT statements from the Database Browser, do one of the following:

Click a database object (such as a table or view), or a folder, in the Database Browser and drag it into the SQL Editor.

dbquery_sql_generate

Right-click a database object in the Database Browser and select Show in SQL Editor | Select.

 

 

To create SQL statements manually:

1.Start entering the SQL statement in the SQL Editor. If autocompletion is set to occur automatically, a drop-down list with suggestions appears while you enter statement.

mf_autocompletion

2.Use the cursor Up and Down keys to select a suggestion, and then press Enter to insert the highlighted option (see also SQL Auto-Completion Suggestions).

© 2019 Altova GmbH