Wählen Sie Ihren SQL-Server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Neuheiten abonnieren
Partners

MaxDB Code Factory online Help

Prev Return to chapter overview Next

Executing query

SQL Editor provides you with several variants of the query executing.

 

To execute all statements of the text area with result data, click the Execute query item of the Navigation bar or use F8 or F9 shortcuts. Each statement is executed in a separate thread in order to continue your work with the software while the query is executing.

 

You can also execute query as script (Shift+F8, Shift+F9). In this case the query does not return data.

 

To execute only a part of the query text, use Execute selected only or Alt+F8, Alt+F9 shortcuts.

 

If the query text is correct, the query is executed, and if the query statement is supposed to return data (e.g. SELECT statement), the Result tab opens with the data returned by the query. If an error occurs while executing the query, execution stop is stopped and the appropriate error message is displayed in the Information tab.

 

The Result area displays the result data in grid. All principles of working with data you can find in Data Management section.
 



Prev Return to chapter overview Next