602SQL Development and Management Client

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:

The server name and application name (or ODBC data source) is displayed at the top.
Enter the SQL statement on the left. Use Ctrl+Enter to insert a new line (press Enter to execute the command).
The control buttons Execute, Previous command and Next command and the checkbox Debug mode are on the right. Check the Debug mode checkbox to force the command to execute in debug mode.

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.

Monitor Window

602SQL Development and Management Client

Output Window