Please enable JavaScript to view this site.

Altova MapForce 2020 Professional Edition

The Results tab of the DB Query pane shows the recordset retrieved as a result of a database query.

dbquery_results

The toolbar buttons enable navigation between results and SQL statements and facilitate searching within the query results.

 

ic-find-indb

Find: Searches a specific text within the displayed results. Press F3 to go to the next occurrence of the search term.

ic_goto-statment

Go to statement: Jumps to the SQL Editor and highlights the SQL statement that produced the current result. This might be particularly useful when the SQL Editor contains multiple statements.

 

 

To select cells from the query results:

Click a column header to select the entire column

Click a row number to select the entire row

Click individual cells. Holding down the Ctrl key while clicking allows you to make multiple selections. If a column or cell contains XML data then this data can also be copied.

 

Note: The context menu can also be used to select data, Selection | Row | Column | All.

 

 

To copy the selected cells to clipboard:

Right-click and select Copy selected cells from the context menu.

 

 

To sort data:

Right-click anywhere in the column to be sorted and select Sorting | Ascending or Descending

Click the sort icon in the column header

dbq-sort-col

The data is sorted according to the contents of the sorted column.

 

 

To restore the default sort order:

Right-click anywhere in the table and choose Sorting | Restore default from the context menu.

© 2019 Altova GmbH