Altova MapForce 2023 Enterprise Edition

The Messages tab of the DB Query pane provides specific information about the last executed SQL statement and reports errors or warning messages.

dbquery_messages

You can use different filters to customize the view of the Messages tab or use the Next and Previous buttons to browse data row by row. The buttons at the top are used to navigate the messages, copy text to clipboard, and hide certain parts of the message. These options are also available in the context menu, when you right-click anywhere inside the Messages tab.

 

ic_filter

Filter: Opens a pop-up menu from where you can filter out the individual message types (Summary, Success, Warning, Error, Autoinsertion, Progress). "Autoinsertion" refers to those messages that may be triggered when SQL statements or SQL constructs are inserted automatically in SQL Editor. "Progress" messages report the database connection result, as well as the outcome of SQL parsing and data structure loading.

 

You can check all or none of these options with a single mouse click by selecting either Check All or Uncheck All from the pop-up menu.

ic_next-SQL

Next: Jumps to and highlights the next message.

ic_previous-SQL

Previous: Jumps to and highlights the previous message.

ic_copy-msg

Copy selected message to the clipboard

ic_copy-msg_children

Copy selected message including its children to the clipboard

ic_copy-all-msg

Copy all messages to the clipboard

ic_find-msg

Find: Opens the Find dialog box.

ic_find-prev-msg

Find previous: Jumps to the previous occurrence of the string specified in the Find dialog box.

ic_find-next-msg

Find next: Jumps to the next occurrence of the string specified in the Find dialog box.

ic_clear-msg

Clear: Removes all messages from the Message tab of the SQL Editor window.

© 2017-2023 Altova GmbH