602SQL Documentation Index  

SQL Console

The SQL console window is used to enter SQL statements or SELECT SQL query phrases. Query phrases are evaluated and an independent window with the grid containing the result (cursor) is displayed. Server response or an error description is displayed in the Output window, SQL output tab.

Commands are executed in the current opened application context or inside an open ODBC connection to an external database. If an application or ODBC connection is not selected, this window is inactive.

This window contains three parts:

If you execute SQL modification commands (CREATE, DROP, ALTER) using this console, the client will not know about these changes and may attempt to work with the original structures and objects. In order to use the latest design, refresh the control panel using the Refresh Control Panel from the menu or toolbar.

Before the SQL statement is sent it's transliterated into the system encoding of the SQL server to prevent the possible truncation of national characters inside the statement.